-- ----------------------------
-- Table structure for sys_config
-- ----------------------------
DROP TABLE IF EXISTS `sys_config`;
CREATE TABLE `sys_config`
(
    `id`           bigint       NOT NULL AUTO_INCREMENT COMMENT '参数配置ID',
    `config_name`  varchar(50)  NOT NULL COMMENT '参数名',
    `config_key`   varchar(50)  NOT NULL COMMENT '参数key',
    `config_value` varchar(512) NOT NULL COMMENT '参数value',
    `locked`       tinyint unsigned default 0 COMMENT '是否锁定',
    `created_by`   bigint           DEFAULT NULL COMMENT '创建人ID',
    `created_at`   datetime         DEFAULT NULL COMMENT '创建时间',
    `updated_by`   bigint           DEFAULT NULL COMMENT '更新人ID',
    `updated_at`   datetime         DEFAULT NULL COMMENT '更新时间',
    `remark`       varchar(255)     DEFAULT NULL COMMENT '备注',
    PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB
  AUTO_INCREMENT = 13
  DEFAULT CHARSET = utf8mb4
  COLLATE = utf8mb4_general_ci
  ROW_FORMAT = DYNAMIC COMMENT ='参数配置表';

-- ----------------------------
-- Records of sys_config
-- ----------------------------
BEGIN;
INSERT INTO `sys_config` (`id`, `config_name`, `config_key`, `config_value`, `locked`, `created_by`, `created_at`,
                          `updated_by`, `updated_at`, `remark`)
VALUES (1, '主体名称', 'sys.dept.entityName', 'xx公司', 1, 1, '2024-03-22 10:42:46', 1, '2024-05-10 19:55:41',
        '公司主体名称');
INSERT INTO `sys_config` (`id`, `config_name`, `config_key`, `config_value`, `locked`, `created_by`, `created_at`,
                          `updated_by`, `updated_at`, `remark`)
VALUES (2, '系统账户-初始密码', 'sys.user.initPwd', 'sz123456', 1, 1, '2024-04-10 09:56:58', 1, '2024-04-10 10:13:28',
        '');
INSERT INTO `sys_config` (`id`, `config_name`, `config_key`, `config_value`, `locked`, `created_by`, `created_at`,
                          `updated_by`, `updated_at`, `remark`)
VALUES (3, '密码错误尝试次数限制', 'sys.pwd.errCnt', '5', 1, 1, '2024-06-05 20:40:21', 1, '2024-06-05 20:50:11',
        '一段时间内的密码最大错误次数');
INSERT INTO `sys_config` (`id`, `config_name`, `config_key`, `config_value`, `locked`, `created_by`, `created_at`,
                          `updated_by`, `updated_at`, `remark`)
VALUES (4, '密码错误冻结时间（分）', 'sys_pwd.lockTime', '30', 1, 1, '2024-06-05 20:42:22', 1, '2024-06-05 20:43:30',
        '时间到期后自动解冻');
INSERT INTO `sys_config` (`id`, `config_name`, `config_key`, `config_value`, `locked`, `created_by`, `created_at`,
                          `updated_by`, `updated_at`, `remark`)
VALUES (5, '业务字典起始号段', 'sys.dict.startNo', '2000', 1, 1, '2024-07-08 17:29:16', NULL, NULL,
        '业务字典起始号段。1000作为默认的系统字典号段。');
INSERT INTO `sys_config` (`id`, `config_name`, `config_key`, `config_value`, `locked`, `created_by`, `created_at`,
                          `updated_by`, `updated_at`, `remark`)
VALUES (6, '是否启用验证码', 'sys.captcha.state', 'true', 1, 1, '2024-11-07 15:39:50', 1, '2025-01-08 15:54:37', '');
INSERT INTO `sys_config` (`id`, `config_name`, `config_key`, `config_value`, `locked`, `created_by`, `created_at`,
                          `updated_by`, `updated_at`, `remark`)
VALUES (7, '验证码有效时间（秒）', 'sys.captcha.expire', '120', 1, 1, '2025-01-08 22:06:40', NULL, NULL, NULL);
INSERT INTO `sys_config` (`id`, `config_name`, `config_key`, `config_value`, `locked`, `created_by`, `created_at`,
                          `updated_by`, `updated_at`, `remark`)
VALUES (8, '验证码请求次数限制', 'sys.captcha.requestLimit', '0', 1, 1, '2025-01-08 22:09:28', 1,
        '2025-01-09 09:37:10', '一段时间内的验证码请求次数上限（0为不限制）');
INSERT INTO `sys_config` (`id`, `config_name`, `config_key`, `config_value`, `locked`, `created_by`, `created_at`,
                          `updated_by`, `updated_at`, `remark`)
VALUES (9, '验证码计数周期（分）', 'sys.captcha.requestCycle', '1440', 1, 1, '2025-01-08 22:13:09', 1,
        '2025-01-09 09:38:10', '默认一天');
INSERT INTO `sys_config` (`id`, `config_name`, `config_key`, `config_value`, `locked`, `created_by`, `created_at`,
                          `updated_by`, `updated_at`, `remark`)
VALUES (10, '验证码水印', 'sys.captcha.waterText', 'Sz-Admin', 1, 1, '2025-01-08 22:15:00', 1, '2025-01-09 09:39:15',
        '验证码右下角水印图案');
INSERT INTO `sys_config` (`id`, `config_name`, `config_key`, `config_value`, `locked`, `created_by`, `created_at`,
                          `updated_by`, `updated_at`, `remark`)
VALUES (11, '是否启用验证码水印', 'sys.captcha.waterEnable', 'true', 1, 1, '2025-01-08 22:18:10', 1,
        '2025-01-09 09:39:36', '');
INSERT INTO `sys_config` (`id`, `config_name`, `config_key`, `config_value`, `locked`, `created_by`, `created_at`,
                          `updated_by`, `updated_at`, `remark`)
VALUES (12, '水印字体', 'sys.captcha.waterFont', 'Arial', 1, 1, '2025-01-09 08:58:33', NULL, NULL,
        '请确认服务器是否支持该字体，并注意在商业用途中需确保字体版权合法使用');
COMMIT;

-- ----------------------------
-- Table structure for sys_data_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_data_role`;
CREATE TABLE `sys_data_role`
(
    `id`            bigint           NOT NULL AUTO_INCREMENT COMMENT '数据角色ID',
    `role_name`     varchar(64)      NOT NULL COMMENT '角色名称',
    `data_scope_cd` varchar(10)               DEFAULT NULL COMMENT '数据权限，data_scope字典',
    `remark`        varchar(255)     NOT NULL DEFAULT '' COMMENT '简介',
    `deleted`       tinyint unsigned NOT NULL default 0 COMMENT '删除与否',
    `locked`        tinyint unsigned          default 0 COMMENT '是否锁定',
    `created_at`    datetime                  DEFAULT NULL COMMENT '创建时间',
    `updated_at`    datetime                  DEFAULT NULL COMMENT '更新时间',
    `created_by`    bigint                    DEFAULT NULL COMMENT '创建人ID',
    `updated_by`    bigint                    DEFAULT NULL COMMENT '更新人ID',
    PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB
  AUTO_INCREMENT = 5
  DEFAULT CHARSET = utf8mb4
  COLLATE = utf8mb4_general_ci
  ROW_FORMAT = DYNAMIC COMMENT ='系统数据角色表';

-- ----------------------------
-- Records of sys_data_role
-- ----------------------------
BEGIN;
INSERT INTO `sys_data_role` (`id`, `role_name`, `data_scope_cd`, `remark`, `deleted`, `locked`, `created_at`,
                             `updated_at`, `created_by`, `updated_by`)
VALUES (1, '教师统计-本部门及以下', '1006002', '', 0, 1, '2024-07-15 15:35:05', '2024-07-15 16:57:19', 1, 1);
INSERT INTO `sys_data_role` (`id`, `role_name`, `data_scope_cd`, `remark`, `deleted`, `locked`, `created_at`,
                             `updated_at`, `created_by`, `updated_by`)
VALUES (2, '教师统计-仅本部门', '1006003', '', 0, 1, '2024-07-15 15:36:03', NULL, 1, NULL);
INSERT INTO `sys_data_role` (`id`, `role_name`, `data_scope_cd`, `remark`, `deleted`, `locked`, `created_at`,
                             `updated_at`, `created_by`, `updated_by`)
VALUES (3, '教师统计-仅本人', '1006004', '', 0, 1, '2024-07-15 15:36:46', NULL, 1, NULL);
INSERT INTO `sys_data_role` (`id`, `role_name`, `data_scope_cd`, `remark`, `deleted`, `locked`, `created_at`,
                             `updated_at`, `created_by`, `updated_by`)
VALUES (4, '教师统计-自定义', '1006005', '', 0, 1, '2024-07-15 15:37:27', NULL, 1, NULL);
COMMIT;

-- ----------------------------
-- Table structure for sys_data_role_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_data_role_menu`;
CREATE TABLE `sys_data_role_menu`
(
    `id`      bigint      NOT NULL AUTO_INCREMENT COMMENT 'ID',
    `role_id` bigint DEFAULT NULL COMMENT 'sys_data_role_id （数据角色表ID）',
    `menu_id` varchar(32) NOT NULL COMMENT 'sys_menu_id （菜单表）',
    PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB
  AUTO_INCREMENT = 73
  DEFAULT CHARSET = utf8mb4
  COLLATE = utf8mb4_general_ci
  ROW_FORMAT = DYNAMIC COMMENT ='系统数据角色-菜单表';

-- ----------------------------
-- Records of sys_data_role_menu
-- ----------------------------
BEGIN;
INSERT INTO `sys_data_role_menu` (`id`, `role_id`, `menu_id`)
VALUES (69, 2, '85b54322630f43a39296488a5e76ba16');
INSERT INTO `sys_data_role_menu` (`id`, `role_id`, `menu_id`)
VALUES (70, 3, '85b54322630f43a39296488a5e76ba16');
INSERT INTO `sys_data_role_menu` (`id`, `role_id`, `menu_id`)
VALUES (71, 4, '85b54322630f43a39296488a5e76ba16');
INSERT INTO `sys_data_role_menu` (`id`, `role_id`, `menu_id`)
VALUES (72, 1, '85b54322630f43a39296488a5e76ba16');
COMMIT;

-- ----------------------------
-- Table structure for sys_data_role_relation
-- ----------------------------
DROP TABLE IF EXISTS `sys_data_role_relation`;
CREATE TABLE `sys_data_role_relation`
(
    `id`               bigint NOT NULL AUTO_INCREMENT COMMENT 'ID',
    `role_id`          bigint      DEFAULT NULL COMMENT 'sys_data_role_id （数据角色表ID）',
    `relation_type_cd` varchar(10) DEFAULT NULL COMMENT '关联类型，data_scope_relation_type',
    `relation_id`      bigint      DEFAULT NULL COMMENT '关联表id，联动relation_type_cd（部门ID或个人ID）',
    PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB
  AUTO_INCREMENT = 74
  DEFAULT CHARSET = utf8mb4
  COLLATE = utf8mb4_general_ci
  ROW_FORMAT = DYNAMIC COMMENT ='系统数据角色-关联表';

-- ----------------------------
-- Records of sys_data_role_relation
-- ----------------------------
BEGIN;
INSERT INTO `sys_data_role_relation` (`id`, `role_id`, `relation_type_cd`, `relation_id`)
VALUES (69, 2, '1007001', 15);
INSERT INTO `sys_data_role_relation` (`id`, `role_id`, `relation_type_cd`, `relation_id`)
VALUES (70, 3, '1007001', 15);
INSERT INTO `sys_data_role_relation` (`id`, `role_id`, `relation_type_cd`, `relation_id`)
VALUES (71, 4, '1007002', 5);
INSERT INTO `sys_data_role_relation` (`id`, `role_id`, `relation_type_cd`, `relation_id`)
VALUES (72, 4, '1007002', 3);
INSERT INTO `sys_data_role_relation` (`id`, `role_id`, `relation_type_cd`, `relation_id`)
VALUES (73, 1, '1007001', 4);
COMMIT;

-- ----------------------------
-- Table structure for sys_dept
-- ----------------------------
DROP TABLE IF EXISTS `sys_dept`;
CREATE TABLE `sys_dept`
(
    `id`           bigint           NOT NULL AUTO_INCREMENT COMMENT '部门ID',
    `name`         varchar(32)      NOT NULL COMMENT '部门名称',
    `pid`          bigint           NOT NULL COMMENT '父级ID',
    `deep`         int                       DEFAULT NULL COMMENT '层级',
    `sort`         int                       DEFAULT NULL COMMENT '排序',
    `has_children` tinyint unsigned          default 0 COMMENT '是否有子级',
    `locked`       tinyint unsigned NOT NULL default 0 COMMENT '是否锁定',
    `deleted`      tinyint unsigned NOT NULL default 0 COMMENT '删除标识',
    `remark`       varchar(64)               DEFAULT NULL COMMENT '备注',
    `created_by`   bigint                    DEFAULT NULL COMMENT '创建人ID',
    `updated_by`   bigint                    DEFAULT NULL COMMENT '更新人ID',
    `created_at`   datetime                  DEFAULT NULL COMMENT '创建时间',
    `updated_at`   datetime                  DEFAULT NULL COMMENT '更新时间',
    PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB
  AUTO_INCREMENT = 20
  DEFAULT CHARSET = utf8mb4
  COLLATE = utf8mb4_general_ci
  ROW_FORMAT = DYNAMIC COMMENT ='部门表';

-- ----------------------------
-- Records of sys_dept
-- ----------------------------
BEGIN;
INSERT INTO `sys_dept` (`id`, `name`, `pid`, `deep`, `sort`, `has_children`, `locked`, `deleted`, `remark`,
                        `created_by`, `updated_by`, `created_at`, `updated_at`)
VALUES (1, '技术部', 0, 1, 100, 1, 0, 0, NULL, 1, 1, '2024-05-10 21:40:03', '2024-05-10 21:40:46');
INSERT INTO `sys_dept` (`id`, `name`, `pid`, `deep`, `sort`, `has_children`, `locked`, `deleted`, `remark`,
                        `created_by`, `updated_by`, `created_at`, `updated_at`)
VALUES (2, '运营部', 0, 1, 200, 1, 0, 0, NULL, 1, 1, '2024-05-10 21:40:13', '2024-05-10 21:41:34');
INSERT INTO `sys_dept` (`id`, `name`, `pid`, `deep`, `sort`, `has_children`, `locked`, `deleted`, `remark`,
                        `created_by`, `updated_by`, `created_at`, `updated_at`)
VALUES (3, '财务部', 0, 1, 300, 1, 0, 0, NULL, 1, 1, '2024-05-10 21:40:19', '2024-05-10 21:42:03');
INSERT INTO `sys_dept` (`id`, `name`, `pid`, `deep`, `sort`, `has_children`, `locked`, `deleted`, `remark`,
                        `created_by`, `updated_by`, `created_at`, `updated_at`)
VALUES (4, '研发团队', 1, 4, 100, 1, 0, 0, '', 1, 1, '2024-05-10 21:40:29', '2024-05-11 14:30:38');
INSERT INTO `sys_dept` (`id`, `name`, `pid`, `deep`, `sort`, `has_children`, `locked`, `deleted`, `remark`,
                        `created_by`, `updated_by`, `created_at`, `updated_at`)
VALUES (5, '测试团队', 1, 2, 200, 0, 0, 0, NULL, 1, NULL, '2024-05-10 21:40:36', NULL);
INSERT INTO `sys_dept` (`id`, `name`, `pid`, `deep`, `sort`, `has_children`, `locked`, `deleted`, `remark`,
                        `created_by`, `updated_by`, `created_at`, `updated_at`)
VALUES (6, '运维团队', 1, 2, 300, 0, 0, 0, NULL, 1, NULL, '2024-05-10 21:40:46', NULL);
INSERT INTO `sys_dept` (`id`, `name`, `pid`, `deep`, `sort`, `has_children`, `locked`, `deleted`, `remark`,
                        `created_by`, `updated_by`, `created_at`, `updated_at`)
VALUES (7, '产品运营', 2, 2, 100, 0, 0, 0, NULL, 1, NULL, '2024-05-10 21:41:06', NULL);
INSERT INTO `sys_dept` (`id`, `name`, `pid`, `deep`, `sort`, `has_children`, `locked`, `deleted`, `remark`,
                        `created_by`, `updated_by`, `created_at`, `updated_at`)
VALUES (8, '用户运营', 2, 2, 200, 0, 0, 0, NULL, 1, NULL, '2024-05-10 21:41:34', NULL);
INSERT INTO `sys_dept` (`id`, `name`, `pid`, `deep`, `sort`, `has_children`, `locked`, `deleted`, `remark`,
                        `created_by`, `updated_by`, `created_at`, `updated_at`)
VALUES (9, '会计团队', 3, 2, 100, 0, 0, 0, NULL, 1, NULL, '2024-05-10 21:41:49', NULL);
INSERT INTO `sys_dept` (`id`, `name`, `pid`, `deep`, `sort`, `has_children`, `locked`, `deleted`, `remark`,
                        `created_by`, `updated_by`, `created_at`, `updated_at`)
VALUES (10, '审计团队', 3, 2, 200, 0, 0, 0, NULL, 1, NULL, '2024-05-10 21:42:03', NULL);
INSERT INTO `sys_dept` (`id`, `name`, `pid`, `deep`, `sort`, `has_children`, `locked`, `deleted`, `remark`,
                        `created_by`, `updated_by`, `created_at`, `updated_at`)
VALUES (11, '人力资源部', 0, 1, 400, 0, 0, 0, NULL, 1, NULL, '2024-05-10 21:42:19', NULL);
INSERT INTO `sys_dept` (`id`, `name`, `pid`, `deep`, `sort`, `has_children`, `locked`, `deleted`, `remark`,
                        `created_by`, `updated_by`, `created_at`, `updated_at`)
VALUES (12, '销售部', 0, 1, 500, 0, 0, 0, NULL, 1, NULL, '2024-05-10 21:42:27', NULL);
INSERT INTO `sys_dept` (`id`, `name`, `pid`, `deep`, `sort`, `has_children`, `locked`, `deleted`, `remark`,
                        `created_by`, `updated_by`, `created_at`, `updated_at`)
VALUES (13, '法务部', 0, 1, 600, 0, 0, 0, NULL, 1, NULL, '2024-05-10 21:42:37', NULL);
INSERT INTO `sys_dept` (`id`, `name`, `pid`, `deep`, `sort`, `has_children`, `locked`, `deleted`, `remark`,
                        `created_by`, `updated_by`, `created_at`, `updated_at`)
VALUES (14, '行政部', 0, 1, 700, 0, 0, 0, NULL, 1, NULL, '2024-05-10 21:42:43', NULL);
INSERT INTO `sys_dept` (`id`, `name`, `pid`, `deep`, `sort`, `has_children`, `locked`, `deleted`, `remark`,
                        `created_by`, `updated_by`, `created_at`, `updated_at`)
VALUES (15, '移动组', 4, 3, 100, 0, 0, 0, NULL, 1, NULL, '2024-05-10 21:43:28', NULL);
INSERT INTO `sys_dept` (`id`, `name`, `pid`, `deep`, `sort`, `has_children`, `locked`, `deleted`, `remark`,
                        `created_by`, `updated_by`, `created_at`, `updated_at`)
VALUES (16, '算法组', 4, 3, 200, 0, 0, 0, NULL, 1, NULL, '2024-05-10 21:43:36', NULL);
INSERT INTO `sys_dept` (`id`, `name`, `pid`, `deep`, `sort`, `has_children`, `locked`, `deleted`, `remark`,
                        `created_by`, `updated_by`, `created_at`, `updated_at`)
VALUES (17, '前端组', 4, 3, 300, 0, 0, 0, NULL, 1, NULL, '2024-05-10 21:43:44', NULL);
INSERT INTO `sys_dept` (`id`, `name`, `pid`, `deep`, `sort`, `has_children`, `locked`, `deleted`, `remark`,
                        `created_by`, `updated_by`, `created_at`, `updated_at`)
VALUES (18, '后端组', 4, 4, 400, 1, 0, 0, '', 1, 1, '2024-05-10 21:43:53', '2024-05-10 21:44:12');
INSERT INTO `sys_dept` (`id`, `name`, `pid`, `deep`, `sort`, `has_children`, `locked`, `deleted`, `remark`,
                        `created_by`, `updated_by`, `created_at`, `updated_at`)
VALUES (19, '架构组', 4, 3, 500, 0, 0, 0, NULL, 1, NULL, '2024-05-10 21:44:04', NULL);
COMMIT;

-- ----------------------------
-- Table structure for sys_dept_closure
-- ----------------------------
DROP TABLE IF EXISTS `sys_dept_closure`;
CREATE TABLE `sys_dept_closure`
(
    `ancestor_id`   bigint NOT NULL COMMENT '祖先节点ID',
    `descendant_id` bigint NOT NULL COMMENT '后代节点ID',
    `depth`         int    NOT NULL COMMENT '祖先节点到后代节点的距离'
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4
  COLLATE = utf8mb4_general_ci
  ROW_FORMAT = DYNAMIC COMMENT ='部门祖籍关系表';

-- ----------------------------
-- Records of sys_dept_closure
-- ----------------------------
BEGIN;
INSERT INTO `sys_dept_closure` (`ancestor_id`, `descendant_id`, `depth`)
VALUES (1, 1, 0);
INSERT INTO `sys_dept_closure` (`ancestor_id`, `descendant_id`, `depth`)
VALUES (0, 1, 1);
INSERT INTO `sys_dept_closure` (`ancestor_id`, `descendant_id`, `depth`)
VALUES (2, 2, 0);
INSERT INTO `sys_dept_closure` (`ancestor_id`, `descendant_id`, `depth`)
VALUES (0, 2, 1);
INSERT INTO `sys_dept_closure` (`ancestor_id`, `descendant_id`, `depth`)
VALUES (3, 3, 0);
INSERT INTO `sys_dept_closure` (`ancestor_id`, `descendant_id`, `depth`)
VALUES (0, 3, 1);
INSERT INTO `sys_dept_closure` (`ancestor_id`, `descendant_id`, `depth`)
VALUES (0, 4, 2);
INSERT INTO `sys_dept_closure` (`ancestor_id`, `descendant_id`, `depth`)
VALUES (4, 4, 0);
INSERT INTO `sys_dept_closure` (`ancestor_id`, `descendant_id`, `depth`)
VALUES (1, 4, 1);
INSERT INTO `sys_dept_closure` (`ancestor_id`, `descendant_id`, `depth`)
VALUES (0, 5, 2);
INSERT INTO `sys_dept_closure` (`ancestor_id`, `descendant_id`, `depth`)
VALUES (5, 5, 0);
INSERT INTO `sys_dept_closure` (`ancestor_id`, `descendant_id`, `depth`)
VALUES (1, 5, 1);
INSERT INTO `sys_dept_closure` (`ancestor_id`, `descendant_id`, `depth`)
VALUES (0, 6, 2);
INSERT INTO `sys_dept_closure` (`ancestor_id`, `descendant_id`, `depth`)
VALUES (6, 6, 0);
INSERT INTO `sys_dept_closure` (`ancestor_id`, `descendant_id`, `depth`)
VALUES (1, 6, 1);
INSERT INTO `sys_dept_closure` (`ancestor_id`, `descendant_id`, `depth`)
VALUES (0, 7, 2);
INSERT INTO `sys_dept_closure` (`ancestor_id`, `descendant_id`, `depth`)
VALUES (7, 7, 0);
INSERT INTO `sys_dept_closure` (`ancestor_id`, `descendant_id`, `depth`)
VALUES (2, 7, 1);
INSERT INTO `sys_dept_closure` (`ancestor_id`, `descendant_id`, `depth`)
VALUES (0, 8, 2);
INSERT INTO `sys_dept_closure` (`ancestor_id`, `descendant_id`, `depth`)
VALUES (8, 8, 0);
INSERT INTO `sys_dept_closure` (`ancestor_id`, `descendant_id`, `depth`)
VALUES (2, 8, 1);
INSERT INTO `sys_dept_closure` (`ancestor_id`, `descendant_id`, `depth`)
VALUES (0, 9, 2);
INSERT INTO `sys_dept_closure` (`ancestor_id`, `descendant_id`, `depth`)
VALUES (9, 9, 0);
INSERT INTO `sys_dept_closure` (`ancestor_id`, `descendant_id`, `depth`)
VALUES (3, 9, 1);
INSERT INTO `sys_dept_closure` (`ancestor_id`, `descendant_id`, `depth`)
VALUES (0, 10, 2);
INSERT INTO `sys_dept_closure` (`ancestor_id`, `descendant_id`, `depth`)
VALUES (10, 10, 0);
INSERT INTO `sys_dept_closure` (`ancestor_id`, `descendant_id`, `depth`)
VALUES (3, 10, 1);
INSERT INTO `sys_dept_closure` (`ancestor_id`, `descendant_id`, `depth`)
VALUES (11, 11, 0);
INSERT INTO `sys_dept_closure` (`ancestor_id`, `descendant_id`, `depth`)
VALUES (0, 11, 1);
INSERT INTO `sys_dept_closure` (`ancestor_id`, `descendant_id`, `depth`)
VALUES (12, 12, 0);
INSERT INTO `sys_dept_closure` (`ancestor_id`, `descendant_id`, `depth`)
VALUES (0, 12, 1);
INSERT INTO `sys_dept_closure` (`ancestor_id`, `descendant_id`, `depth`)
VALUES (13, 13, 0);
INSERT INTO `sys_dept_closure` (`ancestor_id`, `descendant_id`, `depth`)
VALUES (0, 13, 1);
INSERT INTO `sys_dept_closure` (`ancestor_id`, `descendant_id`, `depth`)
VALUES (14, 14, 0);
INSERT INTO `sys_dept_closure` (`ancestor_id`, `descendant_id`, `depth`)
VALUES (0, 14, 1);
INSERT INTO `sys_dept_closure` (`ancestor_id`, `descendant_id`, `depth`)
VALUES (0, 15, 3);
INSERT INTO `sys_dept_closure` (`ancestor_id`, `descendant_id`, `depth`)
VALUES (1, 15, 2);
INSERT INTO `sys_dept_closure` (`ancestor_id`, `descendant_id`, `depth`)
VALUES (15, 15, 0);
INSERT INTO `sys_dept_closure` (`ancestor_id`, `descendant_id`, `depth`)
VALUES (4, 15, 1);
INSERT INTO `sys_dept_closure` (`ancestor_id`, `descendant_id`, `depth`)
VALUES (0, 16, 3);
INSERT INTO `sys_dept_closure` (`ancestor_id`, `descendant_id`, `depth`)
VALUES (1, 16, 2);
INSERT INTO `sys_dept_closure` (`ancestor_id`, `descendant_id`, `depth`)
VALUES (16, 16, 0);
INSERT INTO `sys_dept_closure` (`ancestor_id`, `descendant_id`, `depth`)
VALUES (4, 16, 1);
INSERT INTO `sys_dept_closure` (`ancestor_id`, `descendant_id`, `depth`)
VALUES (0, 17, 3);
INSERT INTO `sys_dept_closure` (`ancestor_id`, `descendant_id`, `depth`)
VALUES (1, 17, 2);
INSERT INTO `sys_dept_closure` (`ancestor_id`, `descendant_id`, `depth`)
VALUES (17, 17, 0);
INSERT INTO `sys_dept_closure` (`ancestor_id`, `descendant_id`, `depth`)
VALUES (4, 17, 1);
INSERT INTO `sys_dept_closure` (`ancestor_id`, `descendant_id`, `depth`)
VALUES (0, 18, 3);
INSERT INTO `sys_dept_closure` (`ancestor_id`, `descendant_id`, `depth`)
VALUES (1, 18, 2);
INSERT INTO `sys_dept_closure` (`ancestor_id`, `descendant_id`, `depth`)
VALUES (18, 18, 0);
INSERT INTO `sys_dept_closure` (`ancestor_id`, `descendant_id`, `depth`)
VALUES (4, 18, 1);
INSERT INTO `sys_dept_closure` (`ancestor_id`, `descendant_id`, `depth`)
VALUES (0, 19, 3);
INSERT INTO `sys_dept_closure` (`ancestor_id`, `descendant_id`, `depth`)
VALUES (1, 19, 2);
INSERT INTO `sys_dept_closure` (`ancestor_id`, `descendant_id`, `depth`)
VALUES (19, 19, 0);
INSERT INTO `sys_dept_closure` (`ancestor_id`, `descendant_id`, `depth`)
VALUES (4, 19, 1);
COMMIT;

-- ----------------------------
-- Table structure for sys_dept_leader
-- ----------------------------
DROP TABLE IF EXISTS `sys_dept_leader`;
CREATE TABLE `sys_dept_leader`
(
    `id`        bigint NOT NULL AUTO_INCREMENT COMMENT '部门领导人ID',
    `dept_id`   int DEFAULT NULL,
    `leader_id` bigint NOT NULL COMMENT '领导人ID（sys_user_id）',
    PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB
  AUTO_INCREMENT = 2
  DEFAULT CHARSET = utf8mb4
  COLLATE = utf8mb4_general_ci
  ROW_FORMAT = DYNAMIC COMMENT ='部门领导人表';

-- ----------------------------
-- Table structure for sys_dict
-- ----------------------------
DROP TABLE IF EXISTS `sys_dict`;
CREATE TABLE `sys_dict`
(
    `id`                  bigint           NOT NULL COMMENT '字典ID(规则)',
    `sys_dict_type_id`    bigint           NOT NULL COMMENT '关联sys_dict_type ID',
    `code_name`           varchar(64)      NOT NULL COMMENT '字典名称',
    `alias`               varchar(64)      NOT NULL DEFAULT '' COMMENT '字典（Key）别名，某些情况下如果不想使用id作为key',
    `sort`                int              NOT NULL COMMENT '排序(正序)',
    `callback_show_style` varchar(255)              DEFAULT NULL COMMENT '回显样式',
    `remark`              varchar(255)     NOT NULL DEFAULT '' COMMENT '备注',
    `locked`              tinyint unsigned NOT NULL default 0 COMMENT '是否锁定',
    `visibility`          tinyint unsigned NOT NULL DEFAULT 1 COMMENT '是否展示',
    `deleted`             tinyint unsigned NOT NULL default 0 COMMENT '是否删除',
    `created_at`          datetime                  DEFAULT NULL COMMENT '创建时间',
    `updated_at`          datetime                  DEFAULT NULL COMMENT '更新时间',
    `delete_time`         datetime                  DEFAULT NULL COMMENT '删除时间',
    `created_by`          bigint                    DEFAULT NULL COMMENT '创建人ID',
    `updated_by`          bigint                    DEFAULT NULL COMMENT '更新人ID',
    `delete_id`           bigint                    DEFAULT NULL COMMENT '删除人ID',
    PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4
  COLLATE = utf8mb4_general_ci
  ROW_FORMAT = DYNAMIC COMMENT ='字典表';

-- ----------------------------
-- Records of sys_dict
-- ----------------------------
BEGIN;
INSERT INTO `sys_dict` (`id`, `sys_dict_type_id`, `code_name`, `alias`, `sort`, `callback_show_style`, `remark`,
                        `locked`, `visibility`, `deleted`, `created_at`, `updated_at`, `delete_time`, `created_by`,
                        `updated_by`, `delete_id`)
VALUES (1000001, 1000, '正常', '', 1, 'success', '', 0, 1, 0, '2023-08-20 16:30:23', '2024-04-12 15:58:41', NULL,
        NULL, NULL, NULL);
INSERT INTO `sys_dict` (`id`, `sys_dict_type_id`, `code_name`, `alias`, `sort`, `callback_show_style`, `remark`,
                        `locked`, `visibility`, `deleted`, `created_at`, `updated_at`, `delete_time`, `created_by`,
                        `updated_by`, `delete_id`)
VALUES (1000002, 1000, '禁用', '', 2, 'info', '', 0, 1, 0, '2023-08-20 16:33:45', '2024-04-12 15:58:41', NULL,
        NULL, NULL, NULL);
INSERT INTO `sys_dict` (`id`, `sys_dict_type_id`, `code_name`, `alias`, `sort`, `callback_show_style`, `remark`,
                        `locked`, `visibility`, `deleted`, `created_at`, `updated_at`, `delete_time`, `created_by`,
                        `updated_by`, `delete_id`)
VALUES (1000003, 1000, '禁言', '', 3, 'info', '', 0, 1, 0, '2023-08-20 16:33:54', '2024-04-12 15:58:41', NULL,
        NULL, NULL, NULL);
INSERT INTO `sys_dict` (`id`, `sys_dict_type_id`, `code_name`, `alias`, `sort`, `callback_show_style`, `remark`,
                        `locked`, `visibility`, `deleted`, `created_at`, `updated_at`, `delete_time`, `created_by`,
                        `updated_by`, `delete_id`)
VALUES (1001001, 1001, '测试用户', '', 0, 'info', '', 1, 1, 0, '2023-08-20 16:38:58', '2025-01-18 09:25:39', NULL,
        NULL, NULL, NULL);
INSERT INTO `sys_dict` (`id`, `sys_dict_type_id`, `code_name`, `alias`, `sort`, `callback_show_style`, `remark`,
                        `locked`, `visibility`, `deleted`, `created_at`, `updated_at`, `delete_time`, `created_by`,
                        `updated_by`, `delete_id`)
VALUES (1001002, 1001, '超级管理员', '', 0, 'info', '', 1, 1, 0, '2023-08-20 16:39:05', '2025-01-18 09:25:39',
        NULL, NULL, NULL, NULL);
INSERT INTO `sys_dict` (`id`, `sys_dict_type_id`, `code_name`, `alias`, `sort`, `callback_show_style`, `remark`,
                        `locked`, `visibility`, `deleted`, `created_at`, `updated_at`, `delete_time`, `created_by`,
                        `updated_by`, `delete_id`)
VALUES (1001003, 1001, '普通用户', '', 0, 'info', '', 1, 1, 0, '2023-08-20 16:39:11', '2025-01-18 09:25:39', NULL,
        NULL, NULL, NULL);
INSERT INTO `sys_dict` (`id`, `sys_dict_type_id`, `code_name`, `alias`, `sort`, `callback_show_style`, `remark`,
                        `locked`, `visibility`, `deleted`, `created_at`, `updated_at`, `delete_time`, `created_by`,
                        `updated_by`, `delete_id`)
VALUES (1002001, 1002, '目录', '', 1, 'warning', '', 1, 1, 0, '2023-08-21 11:23:05', '2025-01-18 09:25:39', NULL,
        NULL, NULL, NULL);
INSERT INTO `sys_dict` (`id`, `sys_dict_type_id`, `code_name`, `alias`, `sort`, `callback_show_style`, `remark`,
                        `locked`, `visibility`, `deleted`, `created_at`, `updated_at`, `delete_time`, `created_by`,
                        `updated_by`, `delete_id`)
VALUES (1002002, 1002, '菜单', '', 2, 'success', '', 1, 1, 0, '2023-08-21 11:23:17', '2025-01-18 09:25:39', NULL,
        NULL, NULL, NULL);
INSERT INTO `sys_dict` (`id`, `sys_dict_type_id`, `code_name`, `alias`, `sort`, `callback_show_style`, `remark`,
                        `locked`, `visibility`, `deleted`, `created_at`, `updated_at`, `delete_time`, `created_by`,
                        `updated_by`, `delete_id`)
VALUES (1002003, 1002, '按钮', '', 3, 'danger', '', 1, 1, 0, '2023-08-21 11:23:22', '2025-01-18 09:25:39', NULL,
        NULL, NULL, NULL);
INSERT INTO `sys_dict` (`id`, `sys_dict_type_id`, `code_name`, `alias`, `sort`, `callback_show_style`, `remark`,
                        `locked`, `visibility`, `deleted`, `created_at`, `updated_at`, `delete_time`, `created_by`,
                        `updated_by`, `delete_id`)
VALUES (1003001, 1003, '正常', '', 1, 'success', '', 0, 1, 0, '2024-01-22 09:44:52', '2024-04-12 15:58:41', NULL,
        NULL, NULL, NULL);
INSERT INTO `sys_dict` (`id`, `sys_dict_type_id`, `code_name`, `alias`, `sort`, `callback_show_style`, `remark`,
                        `locked`, `visibility`, `deleted`, `created_at`, `updated_at`, `delete_time`, `created_by`,
                        `updated_by`, `delete_id`)
VALUES (1003002, 1003, '禁用', '', 2, 'info', '', 0, 1, 0, '2024-01-22 09:45:16', '2024-04-12 15:58:41', NULL,
        NULL, NULL, NULL);
INSERT INTO `sys_dict` (`id`, `sys_dict_type_id`, `code_name`, `alias`, `sort`, `callback_show_style`, `remark`,
                        `locked`, `visibility`, `deleted`, `created_at`, `updated_at`, `delete_time`, `created_by`,
                        `updated_by`, `delete_id`)
VALUES (1004001, 1004, 'PC', '', 1, 'success', 'pc端', 0, 1, 0, '2024-01-22 10:03:19', '2024-04-12 15:58:41',
        NULL, NULL, NULL, NULL);
INSERT INTO `sys_dict` (`id`, `sys_dict_type_id`, `code_name`, `alias`, `sort`, `callback_show_style`, `remark`,
                        `locked`, `visibility`, `deleted`, `created_at`, `updated_at`, `delete_time`, `created_by`,
                        `updated_by`, `delete_id`)
VALUES (1004002, 1004, '小程序', '', 2, 'success', '小程序端', 0, 1, 0, '2024-01-22 10:03:47',
        '2024-04-12 15:58:41', NULL, NULL, NULL, NULL);
INSERT INTO `sys_dict` (`id`, `sys_dict_type_id`, `code_name`, `alias`, `sort`, `callback_show_style`, `remark`,
                        `locked`, `visibility`, `deleted`, `created_at`, `updated_at`, `delete_time`, `created_by`,
                        `updated_by`, `delete_id`)
VALUES (1004003, 1004, 'Androd', '', 3, 'success', '', 0, 1, 0, '2024-01-22 10:04:35', '2024-04-12 15:58:41',
        NULL, NULL, NULL, NULL);
INSERT INTO `sys_dict` (`id`, `sys_dict_type_id`, `code_name`, `alias`, `sort`, `callback_show_style`, `remark`,
                        `locked`, `visibility`, `deleted`, `created_at`, `updated_at`, `delete_time`, `created_by`,
                        `updated_by`, `delete_id`)
VALUES (1004004, 1004, 'IOS', '', 4, 'success', '', 0, 1, 0, '2024-01-22 10:04:42', '2024-04-12 15:58:41', NULL,
        NULL, NULL, NULL);
INSERT INTO `sys_dict` (`id`, `sys_dict_type_id`, `code_name`, `alias`, `sort`, `callback_show_style`, `remark`,
                        `locked`, `visibility`, `deleted`, `created_at`, `updated_at`, `delete_time`, `created_by`,
                        `updated_by`, `delete_id`)
VALUES (1005001, 1005, '密码认证', 'password', 100, 'success', '', 1, 1, 0, '2024-01-22 10:20:32',
        '2025-01-18 09:25:39', NULL, NULL, NULL, NULL);
INSERT INTO `sys_dict` (`id`, `sys_dict_type_id`, `code_name`, `alias`, `sort`, `callback_show_style`, `remark`,
                        `locked`, `visibility`, `deleted`, `created_at`, `updated_at`, `delete_time`, `created_by`,
                        `updated_by`, `delete_id`)
VALUES (1005002, 1005, '小程序认证', 'applet', 300, 'success', '', 0, 1, 0, '2024-01-22 10:20:40',
        '2024-04-12 16:51:58', NULL, NULL, NULL, NULL);
INSERT INTO `sys_dict` (`id`, `sys_dict_type_id`, `code_name`, `alias`, `sort`, `callback_show_style`, `remark`,
                        `locked`, `visibility`, `deleted`, `created_at`, `updated_at`, `delete_time`, `created_by`,
                        `updated_by`, `delete_id`)
VALUES (1005003, 1005, '三方认证', 'third', 400, 'success', '', 0, 1, 0, '2024-01-22 10:20:51',
        '2024-04-12 16:51:49', NULL, NULL, NULL, NULL);
INSERT INTO `sys_dict` (`id`, `sys_dict_type_id`, `code_name`, `alias`, `sort`, `callback_show_style`, `remark`,
                        `locked`, `visibility`, `deleted`, `created_at`, `updated_at`, `delete_time`, `created_by`,
                        `updated_by`, `delete_id`)
VALUES (1005004, 1005, '短信认证', 'sms', 200, 'success', '', 0, 1, 0, '2024-01-22 10:20:57',
        '2024-04-12 16:51:41', NULL, NULL, NULL, NULL);
INSERT INTO `sys_dict` (`id`, `sys_dict_type_id`, `code_name`, `alias`, `sort`, `callback_show_style`, `remark`,
                        `locked`, `visibility`, `deleted`, `created_at`, `updated_at`, `delete_time`, `created_by`,
                        `updated_by`, `delete_id`)
VALUES (1006001, 1006, '全部', '', 1, 'primary', '', 1, 1, 0, '2024-06-25 18:55:48', '2024-06-25 19:11:28', NULL,
        NULL, NULL, NULL);
INSERT INTO `sys_dict` (`id`, `sys_dict_type_id`, `code_name`, `alias`, `sort`, `callback_show_style`, `remark`,
                        `locked`, `visibility`, `deleted`, `created_at`, `updated_at`, `delete_time`, `created_by`,
                        `updated_by`, `delete_id`)
VALUES (1006002, 1006, '本部门及以下', '', 2, 'primary', '', 1, 1, 0, '2024-06-25 18:56:57',
        '2024-06-25 19:11:29', NULL, NULL, NULL, NULL);
INSERT INTO `sys_dict` (`id`, `sys_dict_type_id`, `code_name`, `alias`, `sort`, `callback_show_style`, `remark`,
                        `locked`, `visibility`, `deleted`, `created_at`, `updated_at`, `delete_time`, `created_by`,
                        `updated_by`, `delete_id`)
VALUES (1006003, 1006, '仅本部门', '', 3, 'primary', '', 1, 1, 0, '2024-06-25 18:57:22', '2024-06-25 19:11:32',
        NULL, NULL, NULL, NULL);
INSERT INTO `sys_dict` (`id`, `sys_dict_type_id`, `code_name`, `alias`, `sort`, `callback_show_style`, `remark`,
                        `locked`, `visibility`, `deleted`, `created_at`, `updated_at`, `delete_time`, `created_by`,
                        `updated_by`, `delete_id`)
VALUES (1006004, 1006, '仅本人', '', 4, 'primary', '', 1, 1, 0, '2024-06-25 18:57:57', '2024-06-25 19:11:34',
        NULL, NULL, NULL, NULL);
INSERT INTO `sys_dict` (`id`, `sys_dict_type_id`, `code_name`, `alias`, `sort`, `callback_show_style`, `remark`,
                        `locked`, `visibility`, `deleted`, `created_at`, `updated_at`, `delete_time`, `created_by`,
                        `updated_by`, `delete_id`)
VALUES (1006005, 1006, '自定义', '', 5, 'primary', '', 1, 1, 0, '2024-06-25 18:58:11', '2024-06-25 19:11:36',
        NULL, NULL, NULL, NULL);
INSERT INTO `sys_dict` (`id`, `sys_dict_type_id`, `code_name`, `alias`, `sort`, `callback_show_style`, `remark`,
                        `locked`, `visibility`, `deleted`, `created_at`, `updated_at`, `delete_time`, `created_by`,
                        `updated_by`, `delete_id`)
VALUES (1007001, 1007, '部门权限', '', 1, 'primary', '', 1, 1, 0, '2024-06-25 18:59:00', '2024-06-25 19:11:38',
        NULL, NULL, NULL, NULL);
INSERT INTO `sys_dict` (`id`, `sys_dict_type_id`, `code_name`, `alias`, `sort`, `callback_show_style`, `remark`,
                        `locked`, `visibility`, `deleted`, `created_at`, `updated_at`, `delete_time`, `created_by`,
                        `updated_by`, `delete_id`)
VALUES (1007002, 1007, '个人权限', '', 2, 'primary', '个人权限高优先级', 1, 1, 0, '2024-06-25 18:59:27',
        '2024-06-25 19:11:41', NULL, NULL, NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for sys_dict_type
-- ----------------------------
DROP TABLE IF EXISTS `sys_dict_type`;
CREATE TABLE `sys_dict_type`
(
    `id`          bigint                     NOT NULL AUTO_INCREMENT COMMENT '字典类型ID',
    `type_name`   varchar(64)                NOT NULL DEFAULT '' COMMENT '字典类型名(中文)',
    `type_code`   varchar(64)                NOT NULL COMMENT '字典类型码(英文)',
    `locked`      tinyint unsigned                    default 0 COMMENT '是否锁定，锁定的属性无法在页面进行修改',
    `visibility`  tinyint unsigned                    DEFAULT 1 COMMENT '显示与否',
    `deleted`     tinyint unsigned                    default 0 COMMENT '删除与否',
    `remark`      varchar(255)                        DEFAULT '' COMMENT '描述',
    `created_at`  datetime                            DEFAULT NULL COMMENT '创建时间',
    `updated_at`  datetime                            DEFAULT NULL COMMENT '更新时间',
    `delete_time` datetime                            DEFAULT NULL COMMENT '删除时间',
    `created_by`  bigint                              DEFAULT NULL COMMENT '创建人ID',
    `updated_by`  bigint                              DEFAULT NULL COMMENT '更新人ID',
    `delete_id`   bigint                              DEFAULT NULL COMMENT '删除人ID',
    `type`        enum ('system','business') NOT NULL DEFAULT 'business' COMMENT '字典类型: system 系统, business 业务',
    PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB
  AUTO_INCREMENT = 1008
  DEFAULT CHARSET = utf8mb4
  COLLATE = utf8mb4_general_ci
  ROW_FORMAT = DYNAMIC COMMENT ='字典类型';

-- ----------------------------
-- Records of sys_dict_type
-- ----------------------------
BEGIN;
INSERT INTO `sys_dict_type` (`id`, `type_name`, `type_code`, `locked`, `visibility`, `deleted`, `remark`, `created_at`,
                             `updated_at`, `delete_time`, `created_by`, `updated_by`, `delete_id`, `type`)
VALUES (1000, '账户状态', 'account_status', 1, 1, 0, '', '2023-08-20 11:09:46', '2025-01-18 09:25:39', NULL, NULL,
        NULL, NULL, 'system');
INSERT INTO `sys_dict_type` (`id`, `type_name`, `type_code`, `locked`, `visibility`, `deleted`, `remark`, `created_at`,
                             `updated_at`, `delete_time`, `created_by`, `updated_by`, `delete_id`, `type`)
VALUES (1001, '用户标签', 'user_tag', 1, 1, 0, '', '2023-08-20 14:22:40', '2025-01-18 09:25:39', NULL, NULL, NULL,
        NULL, 'system');
INSERT INTO `sys_dict_type` (`id`, `type_name`, `type_code`, `locked`, `visibility`, `deleted`, `remark`, `created_at`,
                             `updated_at`, `delete_time`, `created_by`, `updated_by`, `delete_id`, `type`)
VALUES (1002, '菜单类型', 'menu_type', 1, 1, 0, '', '2023-08-21 11:20:47', '2025-01-18 09:25:39', NULL, NULL,
        NULL, NULL, 'system');
INSERT INTO `sys_dict_type` (`id`, `type_name`, `type_code`, `locked`, `visibility`, `deleted`, `remark`, `created_at`,
                             `updated_at`, `delete_time`, `created_by`, `updated_by`, `delete_id`, `type`)
VALUES (1003, '授权状态', 'sys_client_status', 1, 1, 0, 'client授权状态', '2023-08-22 09:44:27',
        '2025-01-18 09:25:39', NULL, NULL, NULL, NULL, 'system');
INSERT INTO `sys_dict_type` (`id`, `type_name`, `type_code`, `locked`, `visibility`, `deleted`, `remark`, `created_at`,
                             `updated_at`, `delete_time`, `created_by`, `updated_by`, `delete_id`, `type`)
VALUES (1004, '设备类型', 'device_type', 1, 1, 0, '', '2023-08-22 10:02:11', '2025-01-18 09:25:39', NULL, NULL,
        NULL, NULL, 'system');
INSERT INTO `sys_dict_type` (`id`, `type_name`, `type_code`, `locked`, `visibility`, `deleted`, `remark`, `created_at`,
                             `updated_at`, `delete_time`, `created_by`, `updated_by`, `delete_id`, `type`)
VALUES (1005, '授权类型', 'grant_type', 1, 1, 0, '', '2023-08-22 10:15:58', '2025-01-18 09:25:39', NULL, NULL,
        NULL, NULL, 'system');
INSERT INTO `sys_dict_type` (`id`, `type_name`, `type_code`, `locked`, `visibility`, `deleted`, `remark`, `created_at`,
                             `updated_at`, `delete_time`, `created_by`, `updated_by`, `delete_id`, `type`)
VALUES (1006, '数据权限', 'data_scope', 1, 1, 0, '', '2024-06-25 18:54:21', '2024-06-25 19:12:46', NULL, NULL,
        NULL, NULL, 'system');
INSERT INTO `sys_dict_type` (`id`, `type_name`, `type_code`, `locked`, `visibility`, `deleted`, `remark`, `created_at`,
                             `updated_at`, `delete_time`, `created_by`, `updated_by`, `delete_id`, `type`)
VALUES (1007, '数据权限关联类型', 'data_scope_relation_type', 1, 1, 0, '自定义数据权限的关联类型',
        '2024-06-25 18:55:37', '2024-06-25 19:12:48', NULL, NULL, NULL, NULL, 'system');
COMMIT;

-- ----------------------------
-- Table structure for sys_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_menu`;
CREATE TABLE `sys_menu`
(
    `id`             varchar(32)      NOT NULL COMMENT '菜单表id',
    `pid`            varchar(32)      NOT NULL COMMENT '父级id',
    `path`           varchar(255)     NOT NULL DEFAULT '' COMMENT '路径',
    `name`           varchar(64)               DEFAULT '' COMMENT '路由名称',
    `title`          varchar(64)      NOT NULL COMMENT '标题',
    `icon`           varchar(64)               DEFAULT '' COMMENT 'icon图标',
    `component`      varchar(255)              DEFAULT '' COMMENT '组件路径',
    `redirect`       varchar(255)              DEFAULT '' COMMENT '外链地址',
    `sort`           int              NOT NULL COMMENT '排序',
    `deep`           int              NOT NULL COMMENT '层级',
    `menu_type_cd`   varchar(32)      NOT NULL DEFAULT '' COMMENT '菜单类型 （字典表menu_type）',
    `permissions`    varchar(64)               DEFAULT '' COMMENT '按钮权限',
    `is_hidden`      tinyint unsigned          default 0 COMMENT '是否隐藏',
    `has_children`   tinyint unsigned NOT NULL default 0 COMMENT '是否有子级',
    `is_link`        tinyint unsigned          default 0 COMMENT '路由外链时填写的访问地址',
    `is_full`        tinyint unsigned          default 0 COMMENT '菜单是否全屏',
    `is_affix`       tinyint unsigned          default 0 COMMENT '菜单是否固定在标签页',
    `is_keep_alive`  tinyint unsigned          default 0 COMMENT '当前路由是否缓存',
    `created_at`     datetime                  DEFAULT NULL COMMENT '创建时间',
    `updated_at`     datetime                  DEFAULT NULL COMMENT '更新时间',
    `created_by`     bigint                    DEFAULT NULL COMMENT '创建人ID',
    `updated_by`     bigint                    DEFAULT NULL COMMENT '更新人ID',
    `deleted`        tinyint unsigned NOT NULL default 0 COMMENT '是否删除',
    `delete_id`      bigint                    DEFAULT NULL COMMENT '删除人ID',
    `delete_time`    datetime                  DEFAULT NULL COMMENT '删除时间',
    `use_data_scope` tinyint unsigned          default 0 COMMENT '菜单是否开启数据权限',
    PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4
  COLLATE = utf8mb4_general_ci
  ROW_FORMAT = DYNAMIC COMMENT ='系统菜单表';

-- ----------------------------
-- Records of sys_menu
-- ----------------------------
BEGIN;
INSERT INTO `sys_menu` (`id`, `pid`, `path`, `name`, `title`, `icon`, `component`, `redirect`, `sort`, `deep`,
                        `menu_type_cd`, `permissions`, `is_hidden`, `has_children`, `is_link`, `is_full`, `is_affix`,
                        `is_keep_alive`, `created_at`, `updated_at`, `created_by`, `updated_by`, `deleted`,
                        `delete_id`, `delete_time`, `use_data_scope`)
VALUES ('006bdbacd71a481f88b6acf895529acd', '8354d626cc65487594a7c38e98de1bad', '', '', '修改', '', '', '', 200, 3,
        '1002003', 'sys.dept.update', 0, 0, 0, 0, 0, 0, '2024-03-19 15:42:48', '2025-01-18 09:25:39', NULL,
        1, 0, NULL, NULL, 0);
INSERT INTO `sys_menu` (`id`, `pid`, `path`, `name`, `title`, `icon`, `component`, `redirect`, `sort`, `deep`,
                        `menu_type_cd`, `permissions`, `is_hidden`, `has_children`, `is_link`, `is_full`, `is_affix`,
                        `is_keep_alive`, `created_at`, `updated_at`, `created_by`, `updated_by`, `deleted`,
                        `delete_id`, `delete_time`, `use_data_scope`)
VALUES ('012efc4ef8d24304a8562534f319524a', '0e529e8a9dbf450898b695e051c36d48', '', '', '预览按钮', '', '', '', 600, 3,
        '1002003', 'generator.preview', 0, 0, 0, 0, 0, 0, '2024-02-15 10:23:47', '2024-05-10 20:54:31', 1,
        1, 0, NULL, NULL, 0);
INSERT INTO `sys_menu` (`id`, `pid`, `path`, `name`, `title`, `icon`, `component`, `redirect`, `sort`, `deep`,
                        `menu_type_cd`, `permissions`, `is_hidden`, `has_children`, `is_link`, `is_full`, `is_affix`,
                        `is_keep_alive`, `created_at`, `updated_at`, `created_by`, `updated_by`, `deleted`,
                        `delete_id`, `delete_time`, `use_data_scope`)
VALUES ('0444cd2c01584f0687264b6205536691', '88b2e5def2ff474fa8bf3537d4a2fe5b', '/system/dataRoleManage',
        'SysDataRoleView', '数据权限', 'svg-scope', '/system/dataRoleManage/index', '', 800, 2, '1002002',
        'sys.data.role.query_table', 0, 1, 0, 0, 0, 0, '2024-07-09 19:19:45', '2025-01-18 09:25:39', NULL,
        1, 0, NULL, NULL, 0);
INSERT INTO `sys_menu` (`id`, `pid`, `path`, `name`, `title`, `icon`, `component`, `redirect`, `sort`, `deep`,
                        `menu_type_cd`, `permissions`, `is_hidden`, `has_children`, `is_link`, `is_full`, `is_affix`,
                        `is_keep_alive`, `created_at`, `updated_at`, `created_by`, `updated_by`, `deleted`,
                        `delete_id`, `delete_time`, `use_data_scope`)
VALUES ('05194ef5fa7a4a308a44f6f5c6791c3a', '99c2ee7b882749e597bcd62385f368fb', '', '', '编辑菜单', '', '', '', 200, 3,
        '1002003', 'sys.menu.update_btn', 0, 0, 0, 0, 0, 0, '2023-08-31 15:31:35', '2024-05-10 20:41:15', 1,
        1, 0, NULL, NULL, 0);
INSERT INTO `sys_menu` (`id`, `pid`, `path`, `name`, `title`, `icon`, `component`, `redirect`, `sort`, `deep`,
                        `menu_type_cd`, `permissions`, `is_hidden`, `has_children`, `is_link`, `is_full`, `is_affix`,
                        `is_keep_alive`, `created_at`, `updated_at`, `created_by`, `updated_by`, `deleted`,
                        `delete_id`, `delete_time`, `use_data_scope`)
VALUES ('0933b165ffc14d558e8de43ccb6687f6', 'c6dd479d5b304731be403d7551c60d70', '', '', '编辑角色', '', '', '', 200, 3,
        '1002003', 'sys.role.update_btn', 0, 0, 0, 0, 0, 0, '2023-09-06 10:30:43', '2024-05-10 20:41:01', 1,
        1, 0, NULL, NULL, 0);
INSERT INTO `sys_menu` (`id`, `pid`, `path`, `name`, `title`, `icon`, `component`, `redirect`, `sort`, `deep`,
                        `menu_type_cd`, `permissions`, `is_hidden`, `has_children`, `is_link`, `is_full`, `is_affix`,
                        `is_keep_alive`, `created_at`, `updated_at`, `created_by`, `updated_by`, `deleted`,
                        `delete_id`, `delete_time`, `use_data_scope`)
VALUES ('0e529e8a9dbf450898b695e051c36d48', 'da1b46db642f42978f83ed5eb34870ce', '/toolbox/generator', 'generator',
        '代码生成', 'Brush', '/toolbox/generator/index', '', 100, 2, '1002002', 'generator.list', 0, 1, 0, 0,
        0, 0, '2023-12-08 13:50:39', '2025-01-18 09:25:39', 1, 1, 0, NULL, NULL, 0);
INSERT INTO `sys_menu` (`id`, `pid`, `path`, `name`, `title`, `icon`, `component`, `redirect`, `sort`, `deep`,
                        `menu_type_cd`, `permissions`, `is_hidden`, `has_children`, `is_link`, `is_full`, `is_affix`,
                        `is_keep_alive`, `created_at`, `updated_at`, `created_by`, `updated_by`, `deleted`,
                        `delete_id`, `delete_time`, `use_data_scope`)
VALUES ('0f98b89c67e54cb0bcff2b56aa98832f', '140c9ed43ef54542bbcdde8a5d928400', '', '', '新增账号', '', '', '', 100, 3,
        '1002003', 'sys.user.create_btn', 0, 0, 0, 0, 0, 0, '2023-09-06 10:31:55', '2024-05-10 20:40:31', 1,
        1, 0, NULL, NULL, 0);
INSERT INTO `sys_menu` (`id`, `pid`, `path`, `name`, `title`, `icon`, `component`, `redirect`, `sort`, `deep`,
                        `menu_type_cd`, `permissions`, `is_hidden`, `has_children`, `is_link`, `is_full`, `is_affix`,
                        `is_keep_alive`, `created_at`, `updated_at`, `created_by`, `updated_by`, `deleted`,
                        `delete_id`, `delete_time`, `use_data_scope`)
VALUES ('13f06419e1d74bda97c0709e3ea0c8f0', 'b06f77bf931947c78cc5883b465bbd19', '', '', '导入', '', '', '', 4, 1,
        '1002003', 'teacher.statistics.import', 0, 0, 0, 0, 0, 0, '2024-05-10 21:45:48',
        '2025-01-18 09:25:39', NULL, NULL, 0, NULL, NULL, 0);
INSERT INTO `sys_menu` (`id`, `pid`, `path`, `name`, `title`, `icon`, `component`, `redirect`, `sort`, `deep`,
                        `menu_type_cd`, `permissions`, `is_hidden`, `has_children`, `is_link`, `is_full`, `is_affix`,
                        `is_keep_alive`, `created_at`, `updated_at`, `created_by`, `updated_by`, `deleted`,
                        `delete_id`, `delete_time`, `use_data_scope`)
VALUES ('140c9ed43ef54542bbcdde8a5d928400', '88b2e5def2ff474fa8bf3537d4a2fe5b', '/system/accountManage',
        'accountManage', '账号管理', 'UserFilled', '/system/accountManage/index', '', 100, 2, '1002002',
        'sys.user.query_table', 0, 1, 0, 0, 0, 1, '2023-08-29 13:53:49', '2024-05-10 20:39:24', 8, 1, 0,
        NULL, NULL, 0);
INSERT INTO `sys_menu` (`id`, `pid`, `path`, `name`, `title`, `icon`, `component`, `redirect`, `sort`, `deep`,
                        `menu_type_cd`, `permissions`, `is_hidden`, `has_children`, `is_link`, `is_full`, `is_affix`,
                        `is_keep_alive`, `created_at`, `updated_at`, `created_by`, `updated_by`, `deleted`,
                        `delete_id`, `delete_time`, `use_data_scope`)
VALUES ('17fc60357760477d8d3ca9619e9b87c4', 'b06f77bf931947c78cc5883b465bbd19', '', '', '修改', '', '', '', 2, 1,
        '1002003', 'teacher.statistics.update', 0, 0, 0, 0, 0, 0, '2024-05-10 21:45:48',
        '2025-01-18 09:25:39', NULL, NULL, 0, NULL, NULL, 0);
INSERT INTO `sys_menu` (`id`, `pid`, `path`, `name`, `title`, `icon`, `component`, `redirect`, `sort`, `deep`,
                        `menu_type_cd`, `permissions`, `is_hidden`, `has_children`, `is_link`, `is_full`, `is_affix`,
                        `is_keep_alive`, `created_at`, `updated_at`, `created_by`, `updated_by`, `deleted`,
                        `delete_id`, `delete_time`, `use_data_scope`)
VALUES ('1a86a9d2b3ca49439277fff9f499c7cd', 'dcb6aabcd910469ebf3efbc7e43282d4', '', '', '删除字典', '', '', '', 600, 3,
        '1002003', 'sys.dict.delete_btn', 0, 0, 0, 0, 0, 0, '2024-02-04 13:58:26', '2024-05-10 20:41:45', 1,
        1, 0, NULL, NULL, 0);
INSERT INTO `sys_menu` (`id`, `pid`, `path`, `name`, `title`, `icon`, `component`, `redirect`, `sort`, `deep`,
                        `menu_type_cd`, `permissions`, `is_hidden`, `has_children`, `is_link`, `is_full`, `is_affix`,
                        `is_keep_alive`, `created_at`, `updated_at`, `created_by`, `updated_by`, `deleted`,
                        `delete_id`, `delete_time`, `use_data_scope`)
VALUES ('26ecd3786ec74a369074f84b9269bc41', 'b06f77bf931947c78cc5883b465bbd19', '', '', '新增', '', '', '', 1, 1,
        '1002003', 'teacher.statistics.create', 0, 0, 0, 0, 0, 0, '2024-05-10 21:45:48',
        '2025-01-18 09:25:39', NULL, NULL, 0, NULL, NULL, 0);
INSERT INTO `sys_menu` (`id`, `pid`, `path`, `name`, `title`, `icon`, `component`, `redirect`, `sort`, `deep`,
                        `menu_type_cd`, `permissions`, `is_hidden`, `has_children`, `is_link`, `is_full`, `is_affix`,
                        `is_keep_alive`, `created_at`, `updated_at`, `created_by`, `updated_by`, `deleted`,
                        `delete_id`, `delete_time`, `use_data_scope`)
VALUES ('2868079355ce4b6c985b1b746dbb0952', 'c4896e8735a745bda9b47ecaf50f46f2', '', '', '新增', '', '', '', 100, 3,
        '1002003', 'sys.file.create', 0, 0, 0, 0, 0, 0, NULL, NULL, NULL, NULL, 0, NULL, NULL, 0);
INSERT INTO `sys_menu` (`id`, `pid`, `path`, `name`, `title`, `icon`, `component`, `redirect`, `sort`, `deep`,
                        `menu_type_cd`, `permissions`, `is_hidden`, `has_children`, `is_link`, `is_full`, `is_affix`,
                        `is_keep_alive`, `created_at`, `updated_at`, `created_by`, `updated_by`, `deleted`,
                        `delete_id`, `delete_time`, `use_data_scope`)
VALUES ('29d33eba6b73420287d8f7e64aea62b3', '88b2e5def2ff474fa8bf3537d4a2fe5b', '/system/configManage', 'configManage',
        '参数管理', 'Key', '/system/configManage/index', '', 500, 2, '1002002', 'sys.config.query_table', 0, 1, 0,
        0, 0, 1, '2023-11-24 09:54:25', '2024-05-10 20:39:43', 1, 1, 0, NULL, NULL, 0);
INSERT INTO `sys_menu` (`id`, `pid`, `path`, `name`, `title`, `icon`, `component`, `redirect`, `sort`, `deep`,
                        `menu_type_cd`, `permissions`, `is_hidden`, `has_children`, `is_link`, `is_full`, `is_affix`,
                        `is_keep_alive`, `created_at`, `updated_at`, `created_by`, `updated_by`, `deleted`,
                        `delete_id`, `delete_time`, `use_data_scope`)
VALUES ('2d6b78ad03de4cf1a3899f25cd7fe0ee', '0e529e8a9dbf450898b695e051c36d48', '', '', '删除按钮', '', '', '', 400, 3,
        '1002003', 'generator.remove', 0, 0, 0, 0, 0, 0, '2024-02-15 10:22:50', '2024-05-10 20:54:24', 1, 1,
        0, NULL, NULL, 0);
INSERT INTO `sys_menu` (`id`, `pid`, `path`, `name`, `title`, `icon`, `component`, `redirect`, `sort`, `deep`,
                        `menu_type_cd`, `permissions`, `is_hidden`, `has_children`, `is_link`, `is_full`, `is_affix`,
                        `is_keep_alive`, `created_at`, `updated_at`, `created_by`, `updated_by`, `deleted`,
                        `delete_id`, `delete_time`, `use_data_scope`)
VALUES ('307951cd49394947b1b7f7dca2266546', '43866b83ef834b73adbd95338f9e606b', '', '', '导出', '', '', '', 5, 1,
        '1002003', 'teacher.statistics.export', 0, 0, 0, 0, 0, 0, '2024-05-10 21:45:32',
        '2025-01-18 09:25:39', NULL, NULL, 0, NULL, NULL, 0);
INSERT INTO `sys_menu` (`id`, `pid`, `path`, `name`, `title`, `icon`, `component`, `redirect`, `sort`, `deep`,
                        `menu_type_cd`, `permissions`, `is_hidden`, `has_children`, `is_link`, `is_full`, `is_affix`,
                        `is_keep_alive`, `created_at`, `updated_at`, `created_by`, `updated_by`, `deleted`,
                        `delete_id`, `delete_time`, `use_data_scope`)
VALUES ('30942929802f41cc850722c78db089e7', '140c9ed43ef54542bbcdde8a5d928400', '', '', '设置数据角色', '', '', '', 800,
        3, '1002003', 'sys.user.data_role_set_btn', 0, 0, 0, 0, 0, 0, '2024-07-02 19:22:37',
        '2024-07-11 20:27:03', 1, 1, 0, NULL, NULL, 0);
INSERT INTO `sys_menu` (`id`, `pid`, `path`, `name`, `title`, `icon`, `component`, `redirect`, `sort`, `deep`,
                        `menu_type_cd`, `permissions`, `is_hidden`, `has_children`, `is_link`, `is_full`, `is_affix`,
                        `is_keep_alive`, `created_at`, `updated_at`, `created_by`, `updated_by`, `deleted`,
                        `delete_id`, `delete_time`, `use_data_scope`)
VALUES ('310d02bb121645d1b7a7f949f48c981b', '0e529e8a9dbf450898b695e051c36d48', '', '', '生成按钮', '', '', '', 300, 3,
        '1002003', 'generator.generator', 0, 0, 0, 0, 0, 0, '2024-02-15 10:21:47', '2024-05-10 20:54:20', 1,
        1, 0, NULL, NULL, 0);
INSERT INTO `sys_menu` (`id`, `pid`, `path`, `name`, `title`, `icon`, `component`, `redirect`, `sort`, `deep`,
                        `menu_type_cd`, `permissions`, `is_hidden`, `has_children`, `is_link`, `is_full`, `is_affix`,
                        `is_keep_alive`, `created_at`, `updated_at`, `created_by`, `updated_by`, `deleted`,
                        `delete_id`, `delete_time`, `use_data_scope`)
VALUES ('330a1a0a857c4ad1a95327db5134e420', '140c9ed43ef54542bbcdde8a5d928400', '', '', '解锁', '', '', '', 500, 3,
        '1002003', 'sys.user.unlock_btn', 0, 0, 0, 0, 0, 0, '2024-02-29 14:06:49', '2024-05-10 20:40:49', 1,
        1, 0, NULL, NULL, 0);
INSERT INTO `sys_menu` (`id`, `pid`, `path`, `name`, `title`, `icon`, `component`, `redirect`, `sort`, `deep`,
                        `menu_type_cd`, `permissions`, `is_hidden`, `has_children`, `is_link`, `is_full`, `is_affix`,
                        `is_keep_alive`, `created_at`, `updated_at`, `created_by`, `updated_by`, `deleted`,
                        `delete_id`, `delete_time`, `use_data_scope`)
VALUES ('3a54d488132b4331bf3cd5e6d86ffcf4', '29d33eba6b73420287d8f7e64aea62b3', '', '', '修改参数', '', '', '', 200, 3,
        '1002003', 'sys.config.update_btn', 0, 0, 0, 0, 0, 0, '2023-11-24 09:57:38', '2024-05-10 20:42:50',
        1, 1, 0, NULL, NULL, 0);
INSERT INTO `sys_menu` (`id`, `pid`, `path`, `name`, `title`, `icon`, `component`, `redirect`, `sort`, `deep`,
                        `menu_type_cd`, `permissions`, `is_hidden`, `has_children`, `is_link`, `is_full`, `is_affix`,
                        `is_keep_alive`, `created_at`, `updated_at`, `created_by`, `updated_by`, `deleted`,
                        `delete_id`, `delete_time`, `use_data_scope`)
VALUES ('3ba9407560a1490583fefa10b22bc74f', '8354d626cc65487594a7c38e98de1bad', '', '', '删除', '', '', '', 300, 3,
        '1002003', 'sys.dept.remove', 0, 0, 0, 0, 0, 0, '2024-03-19 15:42:48', '2025-01-18 09:25:39', NULL,
        1, 0, NULL, NULL, 0);
INSERT INTO `sys_menu` (`id`, `pid`, `path`, `name`, `title`, `icon`, `component`, `redirect`, `sort`, `deep`,
                        `menu_type_cd`, `permissions`, `is_hidden`, `has_children`, `is_link`, `is_full`, `is_affix`,
                        `is_keep_alive`, `created_at`, `updated_at`, `created_by`, `updated_by`, `deleted`,
                        `delete_id`, `delete_time`, `use_data_scope`)
VALUES ('3d7eed8398d3457c897b2e8bf838e9c6', '0e529e8a9dbf450898b695e051c36d48', '', '', '编辑按钮', '', '', '', 200, 3,
        '1002003', 'generator.update', 0, 0, 0, 0, 0, 0, '2024-02-15 10:21:05', '2024-05-10 20:54:15', 1, 1,
        0, NULL, NULL, 0);
INSERT INTO `sys_menu` (`id`, `pid`, `path`, `name`, `title`, `icon`, `component`, `redirect`, `sort`, `deep`,
                        `menu_type_cd`, `permissions`, `is_hidden`, `has_children`, `is_link`, `is_full`, `is_affix`,
                        `is_keep_alive`, `created_at`, `updated_at`, `created_by`, `updated_by`, `deleted`,
                        `delete_id`, `delete_time`, `use_data_scope`)
VALUES ('3f555e4a01174a1d9b29be439668e32f', '0444cd2c01584f0687264b6205536691', '', '', '删除', '', '', '', 300, 3,
        '1002003', 'sys.data.role.remove', 0, 0, 0, 0, 0, 0, '2024-07-09 19:19:11', '2025-01-18 09:25:39',
        NULL, NULL, 0, NULL, NULL, 0);
INSERT INTO `sys_menu` (`id`, `pid`, `path`, `name`, `title`, `icon`, `component`, `redirect`, `sort`, `deep`,
                        `menu_type_cd`, `permissions`, `is_hidden`, `has_children`, `is_link`, `is_full`, `is_affix`,
                        `is_keep_alive`, `created_at`, `updated_at`, `created_by`, `updated_by`, `deleted`,
                        `delete_id`, `delete_time`, `use_data_scope`)
VALUES ('445b73dda9a34ad681d2705a7abcf2f6', 'c6dd479d5b304731be403d7551c60d70', '', '', '删除角色', '', '', '', 300, 3,
        '1002003', 'sys.role.delete_btn', 0, 0, 0, 0, 0, 0, '2023-09-06 10:31:05', '2024-05-10 20:41:04', 1,
        1, 0, NULL, NULL, 0);
INSERT INTO `sys_menu` (`id`, `pid`, `path`, `name`, `title`, `icon`, `component`, `redirect`, `sort`, `deep`,
                        `menu_type_cd`, `permissions`, `is_hidden`, `has_children`, `is_link`, `is_full`, `is_affix`,
                        `is_keep_alive`, `created_at`, `updated_at`, `created_by`, `updated_by`, `deleted`,
                        `delete_id`, `delete_time`, `use_data_scope`)
VALUES ('49c75878b4d445f8be5f69e21e18b70d', 'c4896e8735a745bda9b47ecaf50f46f2', '', '', '修改', '', '', '', 200, 3,
        '1002003', 'sys.file.update', 0, 0, 0, 0, 0, 0, NULL, NULL, NULL, NULL, 0, NULL, NULL, 0);
INSERT INTO `sys_menu` (`id`, `pid`, `path`, `name`, `title`, `icon`, `component`, `redirect`, `sort`, `deep`,
                        `menu_type_cd`, `permissions`, `is_hidden`, `has_children`, `is_link`, `is_full`, `is_affix`,
                        `is_keep_alive`, `created_at`, `updated_at`, `created_by`, `updated_by`, `deleted`,
                        `delete_id`, `delete_time`, `use_data_scope`)
VALUES ('4f39ef0fd2f748f6ab7d6d20d98bc4af', 'dcb6aabcd910469ebf3efbc7e43282d4', '', '', '新增字典类型', '', '', '', 100,
        3, '1002003', 'sys.dict.add_type_btn', 0, 0, 0, 0, 0, 0, '2023-08-31 15:52:38',
        '2024-05-10 20:41:28', 1, 1, 0, NULL, NULL, 0);
INSERT INTO `sys_menu` (`id`, `pid`, `path`, `name`, `title`, `icon`, `component`, `redirect`, `sort`, `deep`,
                        `menu_type_cd`, `permissions`, `is_hidden`, `has_children`, `is_link`, `is_full`, `is_affix`,
                        `is_keep_alive`, `created_at`, `updated_at`, `created_by`, `updated_by`, `deleted`,
                        `delete_id`, `delete_time`, `use_data_scope`)
VALUES ('5b33ac3d630543d09d1388fae4d13fc0', '9e731ff422184fc1be2022c5c985735e', '', '', '修改', '', '', '', 200, 3,
        '1002003', 'sys.client.update', 0, 0, 0, 0, 0, 0, '2024-01-22 10:52:09', '2025-01-18 09:25:39',
        NULL, 1, 0, NULL, NULL, 0);
INSERT INTO `sys_menu` (`id`, `pid`, `path`, `name`, `title`, `icon`, `component`, `redirect`, `sort`, `deep`,
                        `menu_type_cd`, `permissions`, `is_hidden`, `has_children`, `is_link`, `is_full`, `is_affix`,
                        `is_keep_alive`, `created_at`, `updated_at`, `created_by`, `updated_by`, `deleted`,
                        `delete_id`, `delete_time`, `use_data_scope`)
VALUES ('5b5fb3748c6a4ed5a4dda3877508c3a7', 'c6dd479d5b304731be403d7551c60d70', '', '', '设置权限', '', '', '', 400, 3,
        '1002003', 'sys.role.setting_btn', 0, 0, 0, 0, 0, 0, '2023-09-06 10:31:35', '2024-05-10 20:41:07',
        1, 1, 0, NULL, NULL, 0);
INSERT INTO `sys_menu` (`id`, `pid`, `path`, `name`, `title`, `icon`, `component`, `redirect`, `sort`, `deep`,
                        `menu_type_cd`, `permissions`, `is_hidden`, `has_children`, `is_link`, `is_full`, `is_affix`,
                        `is_keep_alive`, `created_at`, `updated_at`, `created_by`, `updated_by`, `deleted`,
                        `delete_id`, `delete_time`, `use_data_scope`)
VALUES ('60966137f6de4d80a0bc6e7781f7df12', '43866b83ef834b73adbd95338f9e606b', '', '', '修改', '', '', '', 2, 1,
        '1002003', 'teacher.statistics.update', 0, 0, 0, 0, 0, 0, '2024-05-10 21:45:32',
        '2025-01-18 09:25:39', NULL, NULL, 0, NULL, NULL, 0);
INSERT INTO `sys_menu` (`id`, `pid`, `path`, `name`, `title`, `icon`, `component`, `redirect`, `sort`, `deep`,
                        `menu_type_cd`, `permissions`, `is_hidden`, `has_children`, `is_link`, `is_full`, `is_affix`,
                        `is_keep_alive`, `created_at`, `updated_at`, `created_by`, `updated_by`, `deleted`,
                        `delete_id`, `delete_time`, `use_data_scope`)
VALUES ('63e71c4867974a86a71e3df8bcd3e2e6', '43866b83ef834b73adbd95338f9e606b', '', '', '删除', '', '', '', 3, 1,
        '1002003', 'teacher.statistics.remove', 0, 0, 0, 0, 0, 0, '2024-05-10 21:45:32',
        '2025-01-18 09:25:39', NULL, NULL, 0, NULL, NULL, 0);
INSERT INTO `sys_menu` (`id`, `pid`, `path`, `name`, `title`, `icon`, `component`, `redirect`, `sort`, `deep`,
                        `menu_type_cd`, `permissions`, `is_hidden`, `has_children`, `is_link`, `is_full`, `is_affix`,
                        `is_keep_alive`, `created_at`, `updated_at`, `created_by`, `updated_by`, `deleted`,
                        `delete_id`, `delete_time`, `use_data_scope`)
VALUES ('686a5522b0334d4da51aa15b3fd1a303', '140c9ed43ef54542bbcdde8a5d928400', '', '', '设置部门', '', '', '', 700, 3,
        '1002003', 'sys.user.dept_set_btn', 0, 0, 0, 0, 0, 0, '2024-04-12 14:33:21', '2025-01-18 09:25:39',
        1, NULL, 0, NULL, NULL, 0);
INSERT INTO `sys_menu` (`id`, `pid`, `path`, `name`, `title`, `icon`, `component`, `redirect`, `sort`, `deep`,
                        `menu_type_cd`, `permissions`, `is_hidden`, `has_children`, `is_link`, `is_full`, `is_affix`,
                        `is_keep_alive`, `created_at`, `updated_at`, `created_by`, `updated_by`, `deleted`,
                        `delete_id`, `delete_time`, `use_data_scope`)
VALUES ('6c15038105da47fa9d519b9cdec7f1cf', '43866b83ef834b73adbd95338f9e606b', '', '', '新增', '', '', '', 1, 1,
        '1002003', 'teacher.statistics.create', 0, 0, 0, 0, 0, 0, '2024-05-10 21:45:32',
        '2025-01-18 09:25:39', NULL, NULL, 0, NULL, NULL, 0);
INSERT INTO `sys_menu` (`id`, `pid`, `path`, `name`, `title`, `icon`, `component`, `redirect`, `sort`, `deep`,
                        `menu_type_cd`, `permissions`, `is_hidden`, `has_children`, `is_link`, `is_full`, `is_affix`,
                        `is_keep_alive`, `created_at`, `updated_at`, `created_by`, `updated_by`, `deleted`,
                        `delete_id`, `delete_time`, `use_data_scope`)
VALUES ('6c46fd01faf042fc9dd4a9c9b9ef2c5a', '9e731ff422184fc1be2022c5c985735e', '', '', '新增', '', '', '', 100, 3,
        '1002003', 'sys.client.create', 0, 0, 0, 0, 0, 0, '2024-01-22 10:52:09', '2025-01-18 09:25:39',
        NULL, 1, 0, NULL, NULL, 0);
INSERT INTO `sys_menu` (`id`, `pid`, `path`, `name`, `title`, `icon`, `component`, `redirect`, `sort`, `deep`,
                        `menu_type_cd`, `permissions`, `is_hidden`, `has_children`, `is_link`, `is_full`, `is_affix`,
                        `is_keep_alive`, `created_at`, `updated_at`, `created_by`, `updated_by`, `deleted`,
                        `delete_id`, `delete_time`, `use_data_scope`)
VALUES ('6e25a716c1a646009a9be90b16f0a682', '140c9ed43ef54542bbcdde8a5d928400', '', '', '设置角色', '', '', '', 400, 3,
        '1002003', 'sys.user.role_set_btn', 0, 0, 0, 0, 0, 0, '2023-09-06 10:33:53', '2024-05-10 20:40:46',
        1, 1, 0, NULL, NULL, 0);
INSERT INTO `sys_menu` (`id`, `pid`, `path`, `name`, `title`, `icon`, `component`, `redirect`, `sort`, `deep`,
                        `menu_type_cd`, `permissions`, `is_hidden`, `has_children`, `is_link`, `is_full`, `is_affix`,
                        `is_keep_alive`, `created_at`, `updated_at`, `created_by`, `updated_by`, `deleted`,
                        `delete_id`, `delete_time`, `use_data_scope`)
VALUES ('7391f12ad51049c2b86d231d39708c71', '85b54322630f43a39296488a5e76ba16', '', '', '修改', '', '', '', 200, 1,
        '1002003', 'teacher.statistics.update', 0, 0, 0, 0, 0, 0, '2024-02-17 10:19:32',
        '2025-01-18 09:25:39', NULL, 1, 0, NULL, NULL, 0);
INSERT INTO `sys_menu` (`id`, `pid`, `path`, `name`, `title`, `icon`, `component`, `redirect`, `sort`, `deep`,
                        `menu_type_cd`, `permissions`, `is_hidden`, `has_children`, `is_link`, `is_full`, `is_affix`,
                        `is_keep_alive`, `created_at`, `updated_at`, `created_by`, `updated_by`, `deleted`,
                        `delete_id`, `delete_time`, `use_data_scope`)
VALUES ('73d312f4fa8949ddba3d9807c0c56f00', '85b54322630f43a39296488a5e76ba16', '', '', '删除', '', '', '', 300, 1,
        '1002003', 'teacher.statistics.remove', 0, 0, 0, 0, 0, 0, '2024-02-17 10:19:32',
        '2025-01-18 09:25:39', NULL, 1, 0, NULL, NULL, 0);
INSERT INTO `sys_menu` (`id`, `pid`, `path`, `name`, `title`, `icon`, `component`, `redirect`, `sort`, `deep`,
                        `menu_type_cd`, `permissions`, `is_hidden`, `has_children`, `is_link`, `is_full`, `is_affix`,
                        `is_keep_alive`, `created_at`, `updated_at`, `created_by`, `updated_by`, `deleted`,
                        `delete_id`, `delete_time`, `use_data_scope`)
VALUES ('7a4544831af34e69aa73148bf84b9924', 'dcb6aabcd910469ebf3efbc7e43282d4', '', '', 'SQL按钮', '', '', '', 700, 3,
        '1002003', 'sys.dict.sql_btn', 0, 0, 0, 0, 0, 0, '2024-08-11 16:10:09', '2025-01-18 09:25:39', 1,
        NULL, 0, NULL, NULL, 0);
INSERT INTO `sys_menu` (`id`, `pid`, `path`, `name`, `title`, `icon`, `component`, `redirect`, `sort`, `deep`,
                        `menu_type_cd`, `permissions`, `is_hidden`, `has_children`, `is_link`, `is_full`, `is_affix`,
                        `is_keep_alive`, `created_at`, `updated_at`, `created_by`, `updated_by`, `deleted`,
                        `delete_id`, `delete_time`, `use_data_scope`)
VALUES ('7abbd9193f9746679e3eead86697e860', '43866b83ef834b73adbd95338f9e606b', '', '', '导入', '', '', '', 4, 1,
        '1002003', 'teacher.statistics.import', 0, 0, 0, 0, 0, 0, '2024-05-10 21:45:32',
        '2025-01-18 09:25:39', NULL, NULL, 0, NULL, NULL, 0);
INSERT INTO `sys_menu` (`id`, `pid`, `path`, `name`, `title`, `icon`, `component`, `redirect`, `sort`, `deep`,
                        `menu_type_cd`, `permissions`, `is_hidden`, `has_children`, `is_link`, `is_full`, `is_affix`,
                        `is_keep_alive`, `created_at`, `updated_at`, `created_by`, `updated_by`, `deleted`,
                        `delete_id`, `delete_time`, `use_data_scope`)
VALUES ('8061d8e79be744bf91b7b438f8e8e887', '85b54322630f43a39296488a5e76ba16', '', '', '导出', '', '', '', 500, 1,
        '1002003', 'teacher.statistics.export', 0, 0, 0, 0, 0, 0, '2024-02-17 10:19:32',
        '2025-01-18 09:25:39', NULL, 1, 0, NULL, NULL, 0);
INSERT INTO `sys_menu` (`id`, `pid`, `path`, `name`, `title`, `icon`, `component`, `redirect`, `sort`, `deep`,
                        `menu_type_cd`, `permissions`, `is_hidden`, `has_children`, `is_link`, `is_full`, `is_affix`,
                        `is_keep_alive`, `created_at`, `updated_at`, `created_by`, `updated_by`, `deleted`,
                        `delete_id`, `delete_time`, `use_data_scope`)
VALUES ('81647226a2d047e8ab0b70472350ee69', 'dcb6aabcd910469ebf3efbc7e43282d4', '', '', '新增字典', '', '', '', 400, 3,
        '1002003', 'sys.dict.add_btn', 0, 0, 0, 0, 0, 0, '2024-02-04 13:54:55', '2024-05-10 20:41:37', 1, 1,
        0, NULL, NULL, 0);
INSERT INTO `sys_menu` (`id`, `pid`, `path`, `name`, `title`, `icon`, `component`, `redirect`, `sort`, `deep`,
                        `menu_type_cd`, `permissions`, `is_hidden`, `has_children`, `is_link`, `is_full`, `is_affix`,
                        `is_keep_alive`, `created_at`, `updated_at`, `created_by`, `updated_by`, `deleted`,
                        `delete_id`, `delete_time`, `use_data_scope`)
VALUES ('818cc6e1889d46579525ad8ab921eeb8', 'dcb6aabcd910469ebf3efbc7e43282d4', '', '', '编辑字典类型', '', '', '', 200,
        3, '1002003', 'sys.dict.update_type_btn', 0, 0, 0, 0, 0, 0, '2023-09-06 10:39:29',
        '2024-05-10 20:41:31', 1, 1, 0, NULL, NULL, 0);
INSERT INTO `sys_menu` (`id`, `pid`, `path`, `name`, `title`, `icon`, `component`, `redirect`, `sort`, `deep`,
                        `menu_type_cd`, `permissions`, `is_hidden`, `has_children`, `is_link`, `is_full`, `is_affix`,
                        `is_keep_alive`, `created_at`, `updated_at`, `created_by`, `updated_by`, `deleted`,
                        `delete_id`, `delete_time`, `use_data_scope`)
VALUES ('8231a369712e4f8f8ac09fce232cd034', '88b2e5def2ff474fa8bf3537d4a2fe5b', '/system/sysTempFile',
        'SysTempFileView', '模版文件管理', 'DocumentCopy', '/system/sysTempFile/index', '', 1000, 2, '1002002',
        'sys.temp.file.query_table', 0, 1, 0, 0, 0, 0, NULL, NULL, NULL, NULL, 0, NULL, NULL, 0);
INSERT INTO `sys_menu` (`id`, `pid`, `path`, `name`, `title`, `icon`, `component`, `redirect`, `sort`, `deep`,
                        `menu_type_cd`, `permissions`, `is_hidden`, `has_children`, `is_link`, `is_full`, `is_affix`,
                        `is_keep_alive`, `created_at`, `updated_at`, `created_by`, `updated_by`, `deleted`,
                        `delete_id`, `delete_time`, `use_data_scope`)
VALUES ('8255bac5eae748a0a8500167963b3e00', '140c9ed43ef54542bbcdde8a5d928400', '', '', '编辑账号', '', '', '', 200, 3,
        '1002003', 'sys.user.update_btn', 0, 0, 0, 0, 0, 0, '2023-09-06 10:32:15', '2024-05-10 20:40:35', 1,
        1, 0, NULL, NULL, 0);
INSERT INTO `sys_menu` (`id`, `pid`, `path`, `name`, `title`, `icon`, `component`, `redirect`, `sort`, `deep`,
                        `menu_type_cd`, `permissions`, `is_hidden`, `has_children`, `is_link`, `is_full`, `is_affix`,
                        `is_keep_alive`, `created_at`, `updated_at`, `created_by`, `updated_by`, `deleted`,
                        `delete_id`, `delete_time`, `use_data_scope`)
VALUES ('82f4776aaf714700802cfb6c93dffa15', 'b06f77bf931947c78cc5883b465bbd19', '', '', '导出', '', '', '', 5, 1,
        '1002003', 'teacher.statistics.export', 0, 0, 0, 0, 0, 0, '2024-05-10 21:45:48',
        '2025-01-18 09:25:39', NULL, NULL, 0, NULL, NULL, 0);
INSERT INTO `sys_menu` (`id`, `pid`, `path`, `name`, `title`, `icon`, `component`, `redirect`, `sort`, `deep`,
                        `menu_type_cd`, `permissions`, `is_hidden`, `has_children`, `is_link`, `is_full`, `is_affix`,
                        `is_keep_alive`, `created_at`, `updated_at`, `created_by`, `updated_by`, `deleted`,
                        `delete_id`, `delete_time`, `use_data_scope`)
VALUES ('8354d626cc65487594a7c38e98de1bad', '88b2e5def2ff474fa8bf3537d4a2fe5b', '/system/deptManage', 'SysDeptView',
        '部门管理', 'svg-org', '/system/deptManage/index', '', 700, 2, '1002002', 'sys.dept.query_table', 0, 1, 0,
        0, 0, 0, '2024-03-19 15:42:48', '2025-01-18 09:25:39', NULL, 1, 0, NULL, NULL, 0);
INSERT INTO `sys_menu` (`id`, `pid`, `path`, `name`, `title`, `icon`, `component`, `redirect`, `sort`, `deep`,
                        `menu_type_cd`, `permissions`, `is_hidden`, `has_children`, `is_link`, `is_full`, `is_affix`,
                        `is_keep_alive`, `created_at`, `updated_at`, `created_by`, `updated_by`, `deleted`,
                        `delete_id`, `delete_time`, `use_data_scope`)
VALUES ('85b54322630f43a39296488a5e76ba16', '0', '/teacher/teacherStatistics', 'TeacherStatisticsView', '教师统计',
        'svg-org', '/teacher/teacherStatistics/index', '', 300, 1, '1002002', 'teacher.statistics.query_table', 0,
        1, 0, 0, 0, 0, '2024-02-17 10:19:32', '2025-01-18 09:25:39', NULL, 1, 0, NULL, NULL, 1);
INSERT INTO `sys_menu` (`id`, `pid`, `path`, `name`, `title`, `icon`, `component`, `redirect`, `sort`, `deep`,
                        `menu_type_cd`, `permissions`, `is_hidden`, `has_children`, `is_link`, `is_full`, `is_affix`,
                        `is_keep_alive`, `created_at`, `updated_at`, `created_by`, `updated_by`, `deleted`,
                        `delete_id`, `delete_time`, `use_data_scope`)
VALUES ('87a26b76daad47c2a12c470605563c4a', '8231a369712e4f8f8ac09fce232cd034', '', '', '修改', '', '', '', 200, 3,
        '1002003', 'sys.temp.file.update', 0, 0, 0, 0, 0, 0, NULL, NULL, NULL, NULL, 0, NULL, NULL, 0);
INSERT INTO `sys_menu` (`id`, `pid`, `path`, `name`, `title`, `icon`, `component`, `redirect`, `sort`, `deep`,
                        `menu_type_cd`, `permissions`, `is_hidden`, `has_children`, `is_link`, `is_full`, `is_affix`,
                        `is_keep_alive`, `created_at`, `updated_at`, `created_by`, `updated_by`, `deleted`,
                        `delete_id`, `delete_time`, `use_data_scope`)
VALUES ('88b2e5def2ff474fa8bf3537d4a2fe5b', '0', '/system', 'system', '系统管理', 'Tools', '', '', 100, 1, '1002001',
        '', 0, 1, 0, 0, 0, 1, '2023-08-29 13:52:10', '2024-05-10 20:38:55', 8, 1, 0, NULL, NULL, 0);
INSERT INTO `sys_menu` (`id`, `pid`, `path`, `name`, `title`, `icon`, `component`, `redirect`, `sort`, `deep`,
                        `menu_type_cd`, `permissions`, `is_hidden`, `has_children`, `is_link`, `is_full`, `is_affix`,
                        `is_keep_alive`, `created_at`, `updated_at`, `created_by`, `updated_by`, `deleted`,
                        `delete_id`, `delete_time`, `use_data_scope`)
VALUES ('8d0b8b57a58e41a5a5e840cc2b3703f4', '9e731ff422184fc1be2022c5c985735e', '', '', '删除', '', '', '', 300, 3,
        '1002003', 'sys.client.remove', 0, 0, 0, 0, 0, 0, '2024-01-22 10:52:09', '2025-01-18 09:25:39',
        NULL, 1, 0, NULL, NULL, 0);
INSERT INTO `sys_menu` (`id`, `pid`, `path`, `name`, `title`, `icon`, `component`, `redirect`, `sort`, `deep`,
                        `menu_type_cd`, `permissions`, `is_hidden`, `has_children`, `is_link`, `is_full`, `is_affix`,
                        `is_keep_alive`, `created_at`, `updated_at`, `created_by`, `updated_by`, `deleted`,
                        `delete_id`, `delete_time`, `use_data_scope`)
VALUES ('8d92cf6f2f3248569d5dd6cb6b958d7c', '0444cd2c01584f0687264b6205536691', '', '', '新增', '', '', '', 100, 3,
        '1002003', 'sys.data.role.create', 0, 0, 0, 0, 0, 0, '2024-07-09 19:19:11', '2025-01-18 09:25:39',
        NULL, NULL, 0, NULL, NULL, 0);
INSERT INTO `sys_menu` (`id`, `pid`, `path`, `name`, `title`, `icon`, `component`, `redirect`, `sort`, `deep`,
                        `menu_type_cd`, `permissions`, `is_hidden`, `has_children`, `is_link`, `is_full`, `is_affix`,
                        `is_keep_alive`, `created_at`, `updated_at`, `created_by`, `updated_by`, `deleted`,
                        `delete_id`, `delete_time`, `use_data_scope`)
VALUES ('8fd6721941494fd5bbe16bec82b235be', '8354d626cc65487594a7c38e98de1bad', '', '', '新增', '', '', '', 100, 3,
        '1002003', 'sys.dept.create', 0, 0, 0, 0, 0, 0, '2024-03-19 15:42:48', '2025-01-18 09:25:39', NULL,
        1, 0, NULL, NULL, 0);
INSERT INTO `sys_menu` (`id`, `pid`, `path`, `name`, `title`, `icon`, `component`, `redirect`, `sort`, `deep`,
                        `menu_type_cd`, `permissions`, `is_hidden`, `has_children`, `is_link`, `is_full`, `is_affix`,
                        `is_keep_alive`, `created_at`, `updated_at`, `created_by`, `updated_by`, `deleted`,
                        `delete_id`, `delete_time`, `use_data_scope`)
VALUES ('91ccb13b5c174583803a4c492a5dfdb6', '85b54322630f43a39296488a5e76ba16', '', '', '导入', '', '', '', 400, 1,
        '1002003', 'teacher.statistics.import', 0, 0, 0, 0, 0, 0, '2024-02-17 10:19:32',
        '2025-01-18 09:25:39', NULL, 1, 0, NULL, NULL, 0);
INSERT INTO `sys_menu` (`id`, `pid`, `path`, `name`, `title`, `icon`, `component`, `redirect`, `sort`, `deep`,
                        `menu_type_cd`, `permissions`, `is_hidden`, `has_children`, `is_link`, `is_full`, `is_affix`,
                        `is_keep_alive`, `created_at`, `updated_at`, `created_by`, `updated_by`, `deleted`,
                        `delete_id`, `delete_time`, `use_data_scope`)
VALUES ('9338bf2f57984825bc227bb618f9db81', '99c2ee7b882749e597bcd62385f368fb', '', '', '新增菜单', '', '', '', 100, 3,
        '1002003', 'sys.menu.create_btn', 0, 0, 0, 0, 0, 0, '2023-08-31 14:27:50', '2024-05-10 20:41:13', 1,
        1, 0, NULL, NULL, 0);
INSERT INTO `sys_menu` (`id`, `pid`, `path`, `name`, `title`, `icon`, `component`, `redirect`, `sort`, `deep`,
                        `menu_type_cd`, `permissions`, `is_hidden`, `has_children`, `is_link`, `is_full`, `is_affix`,
                        `is_keep_alive`, `created_at`, `updated_at`, `created_by`, `updated_by`, `deleted`,
                        `delete_id`, `delete_time`, `use_data_scope`)
VALUES ('97f11d74c98047ba80f011a3da9d882c', 'dcb6aabcd910469ebf3efbc7e43282d4', '', '', '编辑字典', '', '', '', 500, 3,
        '1002003', 'sys.dict.update_btn', 0, 0, 0, 0, 0, 0, '2024-02-04 13:55:13', '2024-05-10 20:41:42', 1,
        1, 0, NULL, NULL, 0);
INSERT INTO `sys_menu` (`id`, `pid`, `path`, `name`, `title`, `icon`, `component`, `redirect`, `sort`, `deep`,
                        `menu_type_cd`, `permissions`, `is_hidden`, `has_children`, `is_link`, `is_full`, `is_affix`,
                        `is_keep_alive`, `created_at`, `updated_at`, `created_by`, `updated_by`, `deleted`,
                        `delete_id`, `delete_time`, `use_data_scope`)
VALUES ('9830d86487184961b90fc527c9604720', 'dcb6aabcd910469ebf3efbc7e43282d4', '', '', '删除字典类型', '', '', '', 300,
        3, '1002003', 'sys.dict.delete_type_btn', 0, 0, 0, 0, 0, 0, '2024-02-04 13:57:33',
        '2024-05-10 20:41:34', 1, 1, 0, NULL, NULL, 0);
INSERT INTO `sys_menu` (`id`, `pid`, `path`, `name`, `title`, `icon`, `component`, `redirect`, `sort`, `deep`,
                        `menu_type_cd`, `permissions`, `is_hidden`, `has_children`, `is_link`, `is_full`, `is_affix`,
                        `is_keep_alive`, `created_at`, `updated_at`, `created_by`, `updated_by`, `deleted`,
                        `delete_id`, `delete_time`, `use_data_scope`)
VALUES ('99c2ee7b882749e597bcd62385f368fb', '88b2e5def2ff474fa8bf3537d4a2fe5b', '/system/menuMange', 'menuMange',
        '菜单管理', 'Menu', '/system/menuMange/index', '', 300, 2, '1002002', 'sys.menu.query_table', 0, 1, 0,
        0, 0, 1, '2023-08-29 13:55:30', '2024-05-10 20:39:34', 8, 1, 0, NULL, NULL, 0);
INSERT INTO `sys_menu` (`id`, `pid`, `path`, `name`, `title`, `icon`, `component`, `redirect`, `sort`, `deep`,
                        `menu_type_cd`, `permissions`, `is_hidden`, `has_children`, `is_link`, `is_full`, `is_affix`,
                        `is_keep_alive`, `created_at`, `updated_at`, `created_by`, `updated_by`, `deleted`,
                        `delete_id`, `delete_time`, `use_data_scope`)
VALUES ('9e731ff422184fc1be2022c5c985735e', '88b2e5def2ff474fa8bf3537d4a2fe5b', '/system/clientManage',
        'ClientManageView', '客户端管理', 'Operation', '/system/clientManage/index', '', 600, 2, '1002002',
        'sys.client.query_table', 0, 1, 0, 0, 0, 0, '2024-01-22 10:52:09', '2025-01-18 09:25:39', NULL, 1,
        0, NULL, NULL, 0);
INSERT INTO `sys_menu` (`id`, `pid`, `path`, `name`, `title`, `icon`, `component`, `redirect`, `sort`, `deep`,
                        `menu_type_cd`, `permissions`, `is_hidden`, `has_children`, `is_link`, `is_full`, `is_affix`,
                        `is_keep_alive`, `created_at`, `updated_at`, `created_by`, `updated_by`, `deleted`,
                        `delete_id`, `delete_time`, `use_data_scope`)
VALUES ('b428eba3f9a34025a46c394df5390b88', '29d33eba6b73420287d8f7e64aea62b3', '', '', '删除参数', '', '', '', 300, 3,
        '1002003', 'sys.config.delete_btn', 0, 0, 0, 0, 0, 0, '2023-11-24 09:58:06', '2024-05-10 20:53:43',
        1, 1, 0, NULL, NULL, 0);
INSERT INTO `sys_menu` (`id`, `pid`, `path`, `name`, `title`, `icon`, `component`, `redirect`, `sort`, `deep`,
                        `menu_type_cd`, `permissions`, `is_hidden`, `has_children`, `is_link`, `is_full`, `is_affix`,
                        `is_keep_alive`, `created_at`, `updated_at`, `created_by`, `updated_by`, `deleted`,
                        `delete_id`, `delete_time`, `use_data_scope`)
VALUES ('b5ce6412c26447348a7267de3ea11a21', '0e529e8a9dbf450898b695e051c36d48', '', '', '导入按钮', '', '', '', 100, 3,
        '1002003', 'generator.import', 0, 0, 0, 0, 0, 0, '2024-02-15 10:19:21', '2024-05-10 20:54:12', 1, 1,
        0, NULL, NULL, 0);
INSERT INTO `sys_menu` (`id`, `pid`, `path`, `name`, `title`, `icon`, `component`, `redirect`, `sort`, `deep`,
                        `menu_type_cd`, `permissions`, `is_hidden`, `has_children`, `is_link`, `is_full`, `is_affix`,
                        `is_keep_alive`, `created_at`, `updated_at`, `created_by`, `updated_by`, `deleted`,
                        `delete_id`, `delete_time`, `use_data_scope`)
VALUES ('c4896e8735a745bda9b47ecaf50f46f2', '88b2e5def2ff474fa8bf3537d4a2fe5b', '/system/fileManage', 'SysFileView',
        '文件管理', 'Files', '/system/fileManage/index', '', 900, 2, '1002002', 'sys.file.query_table', 0, 0, 0,
        0, 0, 0, NULL, NULL, NULL, NULL, 0, NULL, NULL, 0);
INSERT INTO `sys_menu` (`id`, `pid`, `path`, `name`, `title`, `icon`, `component`, `redirect`, `sort`, `deep`,
                        `menu_type_cd`, `permissions`, `is_hidden`, `has_children`, `is_link`, `is_full`, `is_affix`,
                        `is_keep_alive`, `created_at`, `updated_at`, `created_by`, `updated_by`, `deleted`,
                        `delete_id`, `delete_time`, `use_data_scope`)
VALUES ('c55de3135b864579bda79c279f4129a9', 'c4896e8735a745bda9b47ecaf50f46f2', '', '', '删除', '', '', '', 300, 3,
        '1002003', 'sys.file.remove', 0, 0, 0, 0, 0, 0, NULL, NULL, NULL, NULL, 0, NULL, NULL, 0);
INSERT INTO `sys_menu` (`id`, `pid`, `path`, `name`, `title`, `icon`, `component`, `redirect`, `sort`, `deep`,
                        `menu_type_cd`, `permissions`, `is_hidden`, `has_children`, `is_link`, `is_full`, `is_affix`,
                        `is_keep_alive`, `created_at`, `updated_at`, `created_by`, `updated_by`, `deleted`,
                        `delete_id`, `delete_time`, `use_data_scope`)
VALUES ('c6dd479d5b304731be403d7551c60d70', '88b2e5def2ff474fa8bf3537d4a2fe5b', '/system/roleManage', 'roleManage',
        '角色管理', 'User', '/system/roleManage/index', '', 200, 2, '1002002', 'sys.role.query_table', 0, 1, 0,
        0, 0, 1, '2023-08-29 13:54:36', '2024-05-10 20:39:30', 8, 1, 0, NULL, NULL, 0);
INSERT INTO `sys_menu` (`id`, `pid`, `path`, `name`, `title`, `icon`, `component`, `redirect`, `sort`, `deep`,
                        `menu_type_cd`, `permissions`, `is_hidden`, `has_children`, `is_link`, `is_full`, `is_affix`,
                        `is_keep_alive`, `created_at`, `updated_at`, `created_by`, `updated_by`, `deleted`,
                        `delete_id`, `delete_time`, `use_data_scope`)
VALUES ('cb3500315dba4c2d83e4d92edf36dff7', '85b54322630f43a39296488a5e76ba16', '', '', '新增', '', '', '', 100, 1,
        '1002003', 'teacher.statistics.create', 0, 0, 0, 0, 0, 0, '2024-02-17 10:19:32',
        '2025-01-18 09:25:39', NULL, 1, 0, NULL, NULL, 0);
INSERT INTO `sys_menu` (`id`, `pid`, `path`, `name`, `title`, `icon`, `component`, `redirect`, `sort`, `deep`,
                        `menu_type_cd`, `permissions`, `is_hidden`, `has_children`, `is_link`, `is_full`, `is_affix`,
                        `is_keep_alive`, `created_at`, `updated_at`, `created_by`, `updated_by`, `deleted`,
                        `delete_id`, `delete_time`, `use_data_scope`)
VALUES ('cea01dcde9b24b5a8686bdc33c438cd7', '140c9ed43ef54542bbcdde8a5d928400', '', '', '删除账号', '', '', '', 300, 3,
        '1002003', 'sys.user.delete_btn', 0, 0, 0, 0, 0, 0, '2023-09-06 10:33:27', '2024-05-10 20:40:41', 1,
        1, 0, NULL, NULL, 0);
INSERT INTO `sys_menu` (`id`, `pid`, `path`, `name`, `title`, `icon`, `component`, `redirect`, `sort`, `deep`,
                        `menu_type_cd`, `permissions`, `is_hidden`, `has_children`, `is_link`, `is_full`, `is_affix`,
                        `is_keep_alive`, `created_at`, `updated_at`, `created_by`, `updated_by`, `deleted`,
                        `delete_id`, `delete_time`, `use_data_scope`)
VALUES ('da1b46db642f42978f83ed5eb34870ce', '0', '/toolbox', 'toolbox', '工具箱', 'Briefcase', '', '', 200, 1,
        '1002001', '', 0, 1, 0, 0, 0, 0, '2023-12-08 13:46:08', '2024-05-10 20:39:17', 1, 1, 0, NULL,
        NULL, 0);
INSERT INTO `sys_menu` (`id`, `pid`, `path`, `name`, `title`, `icon`, `component`, `redirect`, `sort`, `deep`,
                        `menu_type_cd`, `permissions`, `is_hidden`, `has_children`, `is_link`, `is_full`, `is_affix`,
                        `is_keep_alive`, `created_at`, `updated_at`, `created_by`, `updated_by`, `deleted`,
                        `delete_id`, `delete_time`, `use_data_scope`)
VALUES ('dcb6aabcd910469ebf3efbc7e43282d4', '88b2e5def2ff474fa8bf3537d4a2fe5b', '/system/dictManage', 'dictManage',
        '字典管理', 'Reading', '/system/dictManage/index', '', 400, 2, '1002002', 'sys.dict.query_table', 0, 1, 0,
        0, 0, 1, '2023-08-29 13:57:12', '2024-05-10 20:39:39', 8, 1, 0, NULL, NULL, 0);
INSERT INTO `sys_menu` (`id`, `pid`, `path`, `name`, `title`, `icon`, `component`, `redirect`, `sort`, `deep`,
                        `menu_type_cd`, `permissions`, `is_hidden`, `has_children`, `is_link`, `is_full`, `is_affix`,
                        `is_keep_alive`, `created_at`, `updated_at`, `created_by`, `updated_by`, `deleted`,
                        `delete_id`, `delete_time`, `use_data_scope`)
VALUES ('df2894b4c06e47cab84142d81edc494d', 'c6dd479d5b304731be403d7551c60d70', '', '', '新增角色', '', '', '', 100, 3,
        '1002003', 'sys.role.create_btn', 0, 0, 0, 0, 0, 0, '2023-09-06 10:30:18', '2024-05-10 20:40:57', 1,
        1, 0, NULL, NULL, 0);
INSERT INTO `sys_menu` (`id`, `pid`, `path`, `name`, `title`, `icon`, `component`, `redirect`, `sort`, `deep`,
                        `menu_type_cd`, `permissions`, `is_hidden`, `has_children`, `is_link`, `is_full`, `is_affix`,
                        `is_keep_alive`, `created_at`, `updated_at`, `created_by`, `updated_by`, `deleted`,
                        `delete_id`, `delete_time`, `use_data_scope`)
VALUES ('e19083a9ac404698b4362d63d7048b7b', 'b06f77bf931947c78cc5883b465bbd19', '', '', '删除', '', '', '', 3, 1,
        '1002003', 'teacher.statistics.remove', 0, 0, 0, 0, 0, 0, '2024-05-10 21:45:48',
        '2025-01-18 09:25:39', NULL, NULL, 0, NULL, NULL, 0);
INSERT INTO `sys_menu` (`id`, `pid`, `path`, `name`, `title`, `icon`, `component`, `redirect`, `sort`, `deep`,
                        `menu_type_cd`, `permissions`, `is_hidden`, `has_children`, `is_link`, `is_full`, `is_affix`,
                        `is_keep_alive`, `created_at`, `updated_at`, `created_by`, `updated_by`, `deleted`,
                        `delete_id`, `delete_time`, `use_data_scope`)
VALUES ('e91eeaea8f1546d3921839469fe247b6', '140c9ed43ef54542bbcdde8a5d928400', '', '', '重置密码', '', '', '', 600, 3,
        '1002003', 'sys.user_resetPwd', 0, 0, 0, 0, 0, 0, '2024-04-10 10:16:08', '2025-01-18 09:25:39', 1,
        NULL, 0, NULL, NULL, 0);
INSERT INTO `sys_menu` (`id`, `pid`, `path`, `name`, `title`, `icon`, `component`, `redirect`, `sort`, `deep`,
                        `menu_type_cd`, `permissions`, `is_hidden`, `has_children`, `is_link`, `is_full`, `is_affix`,
                        `is_keep_alive`, `created_at`, `updated_at`, `created_by`, `updated_by`, `deleted`,
                        `delete_id`, `delete_time`, `use_data_scope`)
VALUES ('e931c84b8bc945a7b6ba2d58c8a93afc', '8231a369712e4f8f8ac09fce232cd034', '', '', '新增', '', '', '', 100, 3,
        '1002003', 'sys.temp.file.create', 0, 0, 0, 0, 0, 0, NULL, NULL, NULL, NULL, 0, NULL, NULL, 0);
INSERT INTO `sys_menu` (`id`, `pid`, `path`, `name`, `title`, `icon`, `component`, `redirect`, `sort`, `deep`,
                        `menu_type_cd`, `permissions`, `is_hidden`, `has_children`, `is_link`, `is_full`, `is_affix`,
                        `is_keep_alive`, `created_at`, `updated_at`, `created_by`, `updated_by`, `deleted`,
                        `delete_id`, `delete_time`, `use_data_scope`)
VALUES ('ede76f5e60b640aa9de2ba7216b90ceb', '29d33eba6b73420287d8f7e64aea62b3', '', '', '新增参数', '', '', '', 100, 3,
        '1002003', 'sys.config.add_btn', 0, 0, 0, 0, 0, 0, '2023-11-24 09:57:19', '2024-05-10 20:42:46', 1,
        1, 0, NULL, NULL, 0);
INSERT INTO `sys_menu` (`id`, `pid`, `path`, `name`, `title`, `icon`, `component`, `redirect`, `sort`, `deep`,
                        `menu_type_cd`, `permissions`, `is_hidden`, `has_children`, `is_link`, `is_full`, `is_affix`,
                        `is_keep_alive`, `created_at`, `updated_at`, `created_by`, `updated_by`, `deleted`,
                        `delete_id`, `delete_time`, `use_data_scope`)
VALUES ('ee36ad68586e42fa8a896215c544cb76', '99c2ee7b882749e597bcd62385f368fb', '', '', 'SQL按钮', '', '', '', 400, 3,
        '1002003', 'sys.menu.sql_btn', 0, 0, 0, 0, 0, 0, '2024-01-11 09:41:47', '2024-05-10 20:41:21', 1, 1,
        0, NULL, NULL, 0);
INSERT INTO `sys_menu` (`id`, `pid`, `path`, `name`, `title`, `icon`, `component`, `redirect`, `sort`, `deep`,
                        `menu_type_cd`, `permissions`, `is_hidden`, `has_children`, `is_link`, `is_full`, `is_affix`,
                        `is_keep_alive`, `created_at`, `updated_at`, `created_by`, `updated_by`, `deleted`,
                        `delete_id`, `delete_time`, `use_data_scope`)
VALUES ('f1ef824156c0402c90189d58afb1613e', '8231a369712e4f8f8ac09fce232cd034', '', '', '删除', '', '', '', 300, 3,
        '1002003', 'sys.temp.file.remove', 0, 0, 0, 0, 0, 0, NULL, NULL, NULL, NULL, 0, NULL, NULL, 0);
INSERT INTO `sys_menu` (`id`, `pid`, `path`, `name`, `title`, `icon`, `component`, `redirect`, `sort`, `deep`,
                        `menu_type_cd`, `permissions`, `is_hidden`, `has_children`, `is_link`, `is_full`, `is_affix`,
                        `is_keep_alive`, `created_at`, `updated_at`, `created_by`, `updated_by`, `deleted`,
                        `delete_id`, `delete_time`, `use_data_scope`)
VALUES ('f42b249ccfd44fdcbc2dba48a308c1f6', '0444cd2c01584f0687264b6205536691', '', '', '修改', '', '', '', 200, 3,
        '1002003', 'sys.data.role.update', 0, 0, 0, 0, 0, 0, '2024-07-09 19:19:11', '2025-01-18 09:25:39',
        NULL, NULL, 0, NULL, NULL, 0);
INSERT INTO `sys_menu` (`id`, `pid`, `path`, `name`, `title`, `icon`, `component`, `redirect`, `sort`, `deep`,
                        `menu_type_cd`, `permissions`, `is_hidden`, `has_children`, `is_link`, `is_full`, `is_affix`,
                        `is_keep_alive`, `created_at`, `updated_at`, `created_by`, `updated_by`, `deleted`,
                        `delete_id`, `delete_time`, `use_data_scope`)
VALUES ('fa0c65ad783d4bf9b919a6db02ef1428', '99c2ee7b882749e597bcd62385f368fb', '', '', '删除菜单', '', '', '', 300, 3,
        '1002003', 'sys.menu.delete_btn', 0, 0, 0, 0, 0, 0, '2023-08-31 16:28:57', '2024-05-10 20:41:18', 1,
        1, 0, NULL, NULL, 0);
INSERT INTO `sys_menu` (`id`, `pid`, `path`, `name`, `title`, `icon`, `component`, `redirect`, `sort`, `deep`,
                        `menu_type_cd`, `permissions`, `is_hidden`, `has_children`, `is_link`, `is_full`, `is_affix`,
                        `is_keep_alive`, `created_at`, `updated_at`, `created_by`, `updated_by`, `deleted`,
                        `delete_id`, `delete_time`, `use_data_scope`)
VALUES ('fbdcbcc0ccf547b4b78a4fc2cf303236', '0e529e8a9dbf450898b695e051c36d48', '', '', 'zip下载按钮', '', '', '', 500,
        3, '1002003', 'generator.zip', 0, 0, 0, 0, 0, 0, '2024-02-15 10:23:17', '2024-05-10 20:54:27', 1, 1,
        0, NULL, NULL, 0);
COMMIT;

-- ----------------------------
-- Table structure for sys_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_role`;
CREATE TABLE `sys_role`
(
    `id`          bigint           NOT NULL AUTO_INCREMENT COMMENT '角色ID',
    `role_name`   varchar(64)      NOT NULL COMMENT '角色名称',
    `remark`      varchar(255)     NOT NULL DEFAULT '' COMMENT '简介',
    `deleted`     tinyint unsigned NOT NULL default 0 COMMENT '删除与否',
    `created_at`  datetime                  DEFAULT NULL COMMENT '创建时间',
    `updated_at`  datetime                  DEFAULT NULL COMMENT '更新时间',
    `created_by`  bigint                    DEFAULT NULL COMMENT '创建人ID',
    `updated_by`  bigint                    DEFAULT NULL COMMENT '更新人ID',
    `locked`      tinyint unsigned NOT NULL default 0 COMMENT '是否锁定',
    `permissions` varchar(64)               DEFAULT '' COMMENT '标识，唯一',
    PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB
  AUTO_INCREMENT = 4
  DEFAULT CHARSET = utf8mb4
  COLLATE = utf8mb4_general_ci
  ROW_FORMAT = DYNAMIC COMMENT ='系统角色表';

-- ----------------------------
-- Records of sys_role
-- ----------------------------
BEGIN;
INSERT INTO `sys_role` (`id`, `role_name`, `remark`, `deleted`, `created_at`, `updated_at`, `created_by`, `updated_by`,
                        `locked`, `permissions`)
VALUES (1, '超级管理员', '', 0, '2024-05-10 21:28:31', '2025-01-18 09:25:39', NULL, NULL, 1, 'admin');
INSERT INTO `sys_role` (`id`, `role_name`, `remark`, `deleted`, `created_at`, `updated_at`, `created_by`, `updated_by`,
                        `locked`, `permissions`)
VALUES (2, '字典管理', '', 0, '2024-05-10 21:52:39', '2025-01-18 09:25:39', NULL, NULL, 0, 'dict_menu');
INSERT INTO `sys_role` (`id`, `role_name`, `remark`, `deleted`, `created_at`, `updated_at`, `created_by`, `updated_by`,
                        `locked`, `permissions`)
VALUES (3, '教师统计', '', 0, '2024-05-10 21:53:15', '2025-01-18 09:25:39', NULL, NULL, 0, 'teacher_statics_menu');
COMMIT;

-- ----------------------------
-- Table structure for sys_role_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_menu`;
CREATE TABLE `sys_role_menu`
(
    `id`      bigint      NOT NULL AUTO_INCREMENT COMMENT '系统角色-菜单ID',
    `menu_id` varchar(32) NOT NULL COMMENT 'sys_menu_id （菜单表）',
    `role_id` bigint DEFAULT NULL COMMENT 'sys_role_id （角色表）',
    PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB
  AUTO_INCREMENT = 81
  DEFAULT CHARSET = utf8mb4
  COLLATE = utf8mb4_general_ci
  ROW_FORMAT = DYNAMIC COMMENT ='系统角色-菜单表';

-- ----------------------------
-- Records of sys_role_menu
-- ----------------------------
BEGIN;
INSERT INTO `sys_role_menu` (`id`, `menu_id`, `role_id`)
VALUES (1, '88b2e5def2ff474fa8bf3537d4a2fe5b', 1);
INSERT INTO `sys_role_menu` (`id`, `menu_id`, `role_id`)
VALUES (2, '140c9ed43ef54542bbcdde8a5d928400', 1);
INSERT INTO `sys_role_menu` (`id`, `menu_id`, `role_id`)
VALUES (3, '0f98b89c67e54cb0bcff2b56aa98832f', 1);
INSERT INTO `sys_role_menu` (`id`, `menu_id`, `role_id`)
VALUES (4, '8255bac5eae748a0a8500167963b3e00', 1);
INSERT INTO `sys_role_menu` (`id`, `menu_id`, `role_id`)
VALUES (5, 'cea01dcde9b24b5a8686bdc33c438cd7', 1);
INSERT INTO `sys_role_menu` (`id`, `menu_id`, `role_id`)
VALUES (6, '6e25a716c1a646009a9be90b16f0a682', 1);
INSERT INTO `sys_role_menu` (`id`, `menu_id`, `role_id`)
VALUES (7, '330a1a0a857c4ad1a95327db5134e420', 1);
INSERT INTO `sys_role_menu` (`id`, `menu_id`, `role_id`)
VALUES (8, 'e91eeaea8f1546d3921839469fe247b6', 1);
INSERT INTO `sys_role_menu` (`id`, `menu_id`, `role_id`)
VALUES (9, '686a5522b0334d4da51aa15b3fd1a303', 1);
INSERT INTO `sys_role_menu` (`id`, `menu_id`, `role_id`)
VALUES (10, 'c6dd479d5b304731be403d7551c60d70', 1);
INSERT INTO `sys_role_menu` (`id`, `menu_id`, `role_id`)
VALUES (11, 'df2894b4c06e47cab84142d81edc494d', 1);
INSERT INTO `sys_role_menu` (`id`, `menu_id`, `role_id`)
VALUES (12, '0933b165ffc14d558e8de43ccb6687f6', 1);
INSERT INTO `sys_role_menu` (`id`, `menu_id`, `role_id`)
VALUES (13, '445b73dda9a34ad681d2705a7abcf2f6', 1);
INSERT INTO `sys_role_menu` (`id`, `menu_id`, `role_id`)
VALUES (14, '5b5fb3748c6a4ed5a4dda3877508c3a7', 1);
INSERT INTO `sys_role_menu` (`id`, `menu_id`, `role_id`)
VALUES (15, '99c2ee7b882749e597bcd62385f368fb', 1);
INSERT INTO `sys_role_menu` (`id`, `menu_id`, `role_id`)
VALUES (16, '9338bf2f57984825bc227bb618f9db81', 1);
INSERT INTO `sys_role_menu` (`id`, `menu_id`, `role_id`)
VALUES (17, '05194ef5fa7a4a308a44f6f5c6791c3a', 1);
INSERT INTO `sys_role_menu` (`id`, `menu_id`, `role_id`)
VALUES (18, 'fa0c65ad783d4bf9b919a6db02ef1428', 1);
INSERT INTO `sys_role_menu` (`id`, `menu_id`, `role_id`)
VALUES (19, 'ee36ad68586e42fa8a896215c544cb76', 1);
INSERT INTO `sys_role_menu` (`id`, `menu_id`, `role_id`)
VALUES (20, 'dcb6aabcd910469ebf3efbc7e43282d4', 1);
INSERT INTO `sys_role_menu` (`id`, `menu_id`, `role_id`)
VALUES (21, '4f39ef0fd2f748f6ab7d6d20d98bc4af', 1);
INSERT INTO `sys_role_menu` (`id`, `menu_id`, `role_id`)
VALUES (22, '818cc6e1889d46579525ad8ab921eeb8', 1);
INSERT INTO `sys_role_menu` (`id`, `menu_id`, `role_id`)
VALUES (23, '9830d86487184961b90fc527c9604720', 1);
INSERT INTO `sys_role_menu` (`id`, `menu_id`, `role_id`)
VALUES (24, '81647226a2d047e8ab0b70472350ee69', 1);
INSERT INTO `sys_role_menu` (`id`, `menu_id`, `role_id`)
VALUES (25, '97f11d74c98047ba80f011a3da9d882c', 1);
INSERT INTO `sys_role_menu` (`id`, `menu_id`, `role_id`)
VALUES (26, '1a86a9d2b3ca49439277fff9f499c7cd', 1);
INSERT INTO `sys_role_menu` (`id`, `menu_id`, `role_id`)
VALUES (27, '29d33eba6b73420287d8f7e64aea62b3', 1);
INSERT INTO `sys_role_menu` (`id`, `menu_id`, `role_id`)
VALUES (28, 'ede76f5e60b640aa9de2ba7216b90ceb', 1);
INSERT INTO `sys_role_menu` (`id`, `menu_id`, `role_id`)
VALUES (29, '3a54d488132b4331bf3cd5e6d86ffcf4', 1);
INSERT INTO `sys_role_menu` (`id`, `menu_id`, `role_id`)
VALUES (30, 'b428eba3f9a34025a46c394df5390b88', 1);
INSERT INTO `sys_role_menu` (`id`, `menu_id`, `role_id`)
VALUES (31, '9e731ff422184fc1be2022c5c985735e', 1);
INSERT INTO `sys_role_menu` (`id`, `menu_id`, `role_id`)
VALUES (32, '6c46fd01faf042fc9dd4a9c9b9ef2c5a', 1);
INSERT INTO `sys_role_menu` (`id`, `menu_id`, `role_id`)
VALUES (33, '5b33ac3d630543d09d1388fae4d13fc0', 1);
INSERT INTO `sys_role_menu` (`id`, `menu_id`, `role_id`)
VALUES (34, '8d0b8b57a58e41a5a5e840cc2b3703f4', 1);
INSERT INTO `sys_role_menu` (`id`, `menu_id`, `role_id`)
VALUES (35, '8354d626cc65487594a7c38e98de1bad', 1);
INSERT INTO `sys_role_menu` (`id`, `menu_id`, `role_id`)
VALUES (36, '8fd6721941494fd5bbe16bec82b235be', 1);
INSERT INTO `sys_role_menu` (`id`, `menu_id`, `role_id`)
VALUES (37, '006bdbacd71a481f88b6acf895529acd', 1);
INSERT INTO `sys_role_menu` (`id`, `menu_id`, `role_id`)
VALUES (38, '3ba9407560a1490583fefa10b22bc74f', 1);
INSERT INTO `sys_role_menu` (`id`, `menu_id`, `role_id`)
VALUES (39, '85b54322630f43a39296488a5e76ba16', 1);
INSERT INTO `sys_role_menu` (`id`, `menu_id`, `role_id`)
VALUES (40, 'cb3500315dba4c2d83e4d92edf36dff7', 1);
INSERT INTO `sys_role_menu` (`id`, `menu_id`, `role_id`)
VALUES (41, '7391f12ad51049c2b86d231d39708c71', 1);
INSERT INTO `sys_role_menu` (`id`, `menu_id`, `role_id`)
VALUES (42, '73d312f4fa8949ddba3d9807c0c56f00', 1);
INSERT INTO `sys_role_menu` (`id`, `menu_id`, `role_id`)
VALUES (43, '91ccb13b5c174583803a4c492a5dfdb6', 1);
INSERT INTO `sys_role_menu` (`id`, `menu_id`, `role_id`)
VALUES (44, '8061d8e79be744bf91b7b438f8e8e887', 1);
INSERT INTO `sys_role_menu` (`id`, `menu_id`, `role_id`)
VALUES (45, 'da1b46db642f42978f83ed5eb34870ce', 1);
INSERT INTO `sys_role_menu` (`id`, `menu_id`, `role_id`)
VALUES (46, '0e529e8a9dbf450898b695e051c36d48', 1);
INSERT INTO `sys_role_menu` (`id`, `menu_id`, `role_id`)
VALUES (47, 'b5ce6412c26447348a7267de3ea11a21', 1);
INSERT INTO `sys_role_menu` (`id`, `menu_id`, `role_id`)
VALUES (48, '3d7eed8398d3457c897b2e8bf838e9c6', 1);
INSERT INTO `sys_role_menu` (`id`, `menu_id`, `role_id`)
VALUES (49, '310d02bb121645d1b7a7f949f48c981b', 1);
INSERT INTO `sys_role_menu` (`id`, `menu_id`, `role_id`)
VALUES (50, '2d6b78ad03de4cf1a3899f25cd7fe0ee', 1);
INSERT INTO `sys_role_menu` (`id`, `menu_id`, `role_id`)
VALUES (51, 'fbdcbcc0ccf547b4b78a4fc2cf303236', 1);
INSERT INTO `sys_role_menu` (`id`, `menu_id`, `role_id`)
VALUES (52, '012efc4ef8d24304a8562534f319524a', 1);
INSERT INTO `sys_role_menu` (`id`, `menu_id`, `role_id`)
VALUES (53, 'dcb6aabcd910469ebf3efbc7e43282d4', 2);
INSERT INTO `sys_role_menu` (`id`, `menu_id`, `role_id`)
VALUES (54, '4f39ef0fd2f748f6ab7d6d20d98bc4af', 2);
INSERT INTO `sys_role_menu` (`id`, `menu_id`, `role_id`)
VALUES (55, '818cc6e1889d46579525ad8ab921eeb8', 2);
INSERT INTO `sys_role_menu` (`id`, `menu_id`, `role_id`)
VALUES (56, '9830d86487184961b90fc527c9604720', 2);
INSERT INTO `sys_role_menu` (`id`, `menu_id`, `role_id`)
VALUES (57, '81647226a2d047e8ab0b70472350ee69', 2);
INSERT INTO `sys_role_menu` (`id`, `menu_id`, `role_id`)
VALUES (58, '97f11d74c98047ba80f011a3da9d882c', 2);
INSERT INTO `sys_role_menu` (`id`, `menu_id`, `role_id`)
VALUES (59, '1a86a9d2b3ca49439277fff9f499c7cd', 2);
INSERT INTO `sys_role_menu` (`id`, `menu_id`, `role_id`)
VALUES (60, '88b2e5def2ff474fa8bf3537d4a2fe5b', 2);
INSERT INTO `sys_role_menu` (`id`, `menu_id`, `role_id`)
VALUES (61, '85b54322630f43a39296488a5e76ba16', 3);
INSERT INTO `sys_role_menu` (`id`, `menu_id`, `role_id`)
VALUES (62, 'cb3500315dba4c2d83e4d92edf36dff7', 3);
INSERT INTO `sys_role_menu` (`id`, `menu_id`, `role_id`)
VALUES (63, '7391f12ad51049c2b86d231d39708c71', 3);
INSERT INTO `sys_role_menu` (`id`, `menu_id`, `role_id`)
VALUES (64, '73d312f4fa8949ddba3d9807c0c56f00', 3);
INSERT INTO `sys_role_menu` (`id`, `menu_id`, `role_id`)
VALUES (65, '91ccb13b5c174583803a4c492a5dfdb6', 3);
INSERT INTO `sys_role_menu` (`id`, `menu_id`, `role_id`)
VALUES (66, '8061d8e79be744bf91b7b438f8e8e887', 3);
INSERT INTO `sys_role_menu` (`id`, `menu_id`, `role_id`)
VALUES (67, '30942929802f41cc850722c78db089e7', 1);
INSERT INTO `sys_role_menu` (`id`, `menu_id`, `role_id`)
VALUES (68, '0444cd2c01584f0687264b6205536691', 1);
INSERT INTO `sys_role_menu` (`id`, `menu_id`, `role_id`)
VALUES (69, '8d92cf6f2f3248569d5dd6cb6b958d7c', 1);
INSERT INTO `sys_role_menu` (`id`, `menu_id`, `role_id`)
VALUES (70, 'f42b249ccfd44fdcbc2dba48a308c1f6', 1);
INSERT INTO `sys_role_menu` (`id`, `menu_id`, `role_id`)
VALUES (71, '3f555e4a01174a1d9b29be439668e32f', 1);
INSERT INTO `sys_role_menu` (`id`, `menu_id`, `role_id`)
VALUES (72, '7a4544831af34e69aa73148bf84b9924', 1);
INSERT INTO `sys_role_menu` (`id`, `menu_id`, `role_id`)
VALUES (73, 'c4896e8735a745bda9b47ecaf50f46f2', 1);
INSERT INTO `sys_role_menu` (`id`, `menu_id`, `role_id`)
VALUES (74, '2868079355ce4b6c985b1b746dbb0952', 1);
INSERT INTO `sys_role_menu` (`id`, `menu_id`, `role_id`)
VALUES (75, '49c75878b4d445f8be5f69e21e18b70d', 1);
INSERT INTO `sys_role_menu` (`id`, `menu_id`, `role_id`)
VALUES (76, 'c55de3135b864579bda79c279f4129a9', 1);
INSERT INTO `sys_role_menu` (`id`, `menu_id`, `role_id`)
VALUES (77, '8231a369712e4f8f8ac09fce232cd034', 1);
INSERT INTO `sys_role_menu` (`id`, `menu_id`, `role_id`)
VALUES (78, 'e931c84b8bc945a7b6ba2d58c8a93afc', 1);
INSERT INTO `sys_role_menu` (`id`, `menu_id`, `role_id`)
VALUES (79, '87a26b76daad47c2a12c470605563c4a', 1);
INSERT INTO `sys_role_menu` (`id`, `menu_id`, `role_id`)
VALUES (80, 'f1ef824156c0402c90189d58afb1613e', 1);
COMMIT;

-- ----------------------------
-- Table structure for sys_temp_file
-- ----------------------------
DROP TABLE IF EXISTS `sys_temp_file`;
CREATE TABLE `sys_temp_file`
(
    `id`          bigint NOT NULL AUTO_INCREMENT,
    `sys_file_id` bigint           DEFAULT NULL COMMENT '文件ID',
    `temp_name`   varchar(255)     DEFAULT '' COMMENT '模版名',
    `url`         varchar(512)     DEFAULT '' COMMENT '地址',
    `remark`      varchar(255)     DEFAULT '' COMMENT '备注',
    `deleted`     tinyint unsigned DEFAULT NULL COMMENT '逻辑删除',
    `created_by`  bigint           DEFAULT NULL COMMENT '创建人',
    `created_at`  datetime         DEFAULT NULL COMMENT '创建时间',
    `updated_by`  bigint           DEFAULT NULL COMMENT '更新人',
    `updated_at`  datetime         DEFAULT NULL COMMENT '更新时间',
    PRIMARY KEY (`id`)
) ENGINE = InnoDB
  AUTO_INCREMENT = 2
  DEFAULT CHARSET = utf8mb4
  COLLATE = utf8mb4_general_ci COMMENT ='模版文件表';

-- ----------------------------
-- Records of sys_temp_file
-- ----------------------------
BEGIN;
INSERT INTO `sys_temp_file` (`id`, `sys_file_id`, `temp_name`, `url`, `remark`, `deleted`, `created_by`, `created_at`,
                             `updated_by`, `updated_at`)
VALUES (1, 98, '教师统计模板.xlsx', 'https://minioapi.szadmin.cn/test/tmp/20241216/教师统计 (203323.951).xlsx', '', 0,
        1, '2024-12-16 20:33:12', 1, '2024-12-16 20:33:36');
COMMIT;

-- ----------------------------
-- Table structure for sys_temp_file_history
-- ----------------------------
DROP TABLE IF EXISTS `sys_temp_file_history`;
CREATE TABLE `sys_temp_file_history`
(
    `id`               bigint NOT NULL AUTO_INCREMENT,
    `sys_temp_file_id` bigint       DEFAULT NULL COMMENT '模版文件ID',
    `sys_file_id`      bigint       DEFAULT NULL COMMENT '文件ID',
    `temp_name`        varchar(255) DEFAULT '' COMMENT '模版名',
    `url`              varchar(512) DEFAULT '' COMMENT '地址',
    `remark`           varchar(255) DEFAULT '' COMMENT '备注',
    `created_by`       bigint       DEFAULT NULL COMMENT '创建人',
    `created_at`       datetime     DEFAULT NULL COMMENT '创建时间',
    `updated_by`       bigint       DEFAULT NULL COMMENT '更新人',
    `updated_at`       datetime     DEFAULT NULL COMMENT '更新时间',
    PRIMARY KEY (`id`)
) ENGINE = InnoDB
  AUTO_INCREMENT = 3
  DEFAULT CHARSET = utf8mb4
  COLLATE = utf8mb4_general_ci COMMENT ='模版文件历史表';

-- ----------------------------
-- Records of sys_temp_file_history
-- ----------------------------
BEGIN;
INSERT INTO `sys_temp_file_history` (`id`, `sys_temp_file_id`, `sys_file_id`, `temp_name`, `url`, `remark`,
                                     `created_by`,
                                     `created_at`, `updated_by`, `updated_at`)
VALUES (1, 1, 97, '教师统计模板.xlsx', 'https://minioapi.szadmin.cn/test/tmp/20241216/教师统计 (43) (203252.669).xlsx',
        '', 1, '2024-12-16 20:33:12', NULL, NULL);
INSERT INTO `sys_temp_file_history` (`id`, `sys_temp_file_id`, `sys_file_id`, `temp_name`, `url`, `remark`,
                                     `created_by`,
                                     `created_at`, `updated_by`, `updated_at`)
VALUES (2, 1, 98, '教师统计模板.xlsx', 'https://minioapi.szadmin.cn/test/tmp/20241216/教师统计 (203323.951).xlsx', '',
        1, '2024-12-16 20:33:36', NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for sys_user_data_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_data_role`;
CREATE TABLE `sys_user_data_role`
(
    `id`      bigint NOT NULL AUTO_INCREMENT COMMENT '用户-数据角色关联ID',
    `role_id` bigint DEFAULT NULL COMMENT '数据角色ID (sys_data_role_id)',
    `user_id` bigint DEFAULT NULL COMMENT '用户ID(sys_user_id)',
    PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB
  AUTO_INCREMENT = 5
  DEFAULT CHARSET = utf8mb4
  COLLATE = utf8mb4_general_ci
  ROW_FORMAT = DYNAMIC COMMENT ='系统用户-数据角色关联表';

-- ----------------------------
-- Records of sys_user_data_role
-- ----------------------------
BEGIN;
INSERT INTO `sys_user_data_role` (`id`, `role_id`, `user_id`)
VALUES (1, 2, 4);
INSERT INTO `sys_user_data_role` (`id`, `role_id`, `user_id`)
VALUES (2, 1, 3);
INSERT INTO `sys_user_data_role` (`id`, `role_id`, `user_id`)
VALUES (3, 3, 5);
INSERT INTO `sys_user_data_role` (`id`, `role_id`, `user_id`)
VALUES (4, 4, 6);
COMMIT;

-- ----------------------------
-- Table structure for sys_user_dept
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_dept`;
CREATE TABLE `sys_user_dept`
(
    `id`      bigint NOT NULL AUTO_INCREMENT COMMENT '用户-部门关系ID',
    `dept_id` bigint DEFAULT NULL COMMENT '部门ID (sys_dept_id)',
    `user_id` bigint DEFAULT NULL COMMENT '用户ID(sys_user_id)',
    PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB
  AUTO_INCREMENT = 5
  DEFAULT CHARSET = utf8mb4
  COLLATE = utf8mb4_general_ci
  ROW_FORMAT = DYNAMIC COMMENT ='用户-部门关系表';

-- ----------------------------
-- Records of sys_user_dept
-- ----------------------------
BEGIN;
INSERT INTO `sys_user_dept` (`id`, `dept_id`, `user_id`)
VALUES (1, 4, 2);
INSERT INTO `sys_user_dept` (`id`, `dept_id`, `user_id`)
VALUES (2, 4, 3);
INSERT INTO `sys_user_dept` (`id`, `dept_id`, `user_id`)
VALUES (3, 15, 4);
INSERT INTO `sys_user_dept` (`id`, `dept_id`, `user_id`)
VALUES (4, 15, 5);
COMMIT;

-- ----------------------------
-- Table structure for sys_user_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_role`;
CREATE TABLE `sys_user_role`
(
    `id`      bigint NOT NULL AUTO_INCREMENT COMMENT '用户-角色关联ID',
    `role_id` bigint DEFAULT NULL COMMENT '角色ID (sys_role_id)',
    `user_id` bigint DEFAULT NULL COMMENT '用户ID(sys_user_id)',
    PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB
  AUTO_INCREMENT = 8
  DEFAULT CHARSET = utf8mb4
  COLLATE = utf8mb4_general_ci
  ROW_FORMAT = DYNAMIC COMMENT ='系统用户-角色关联表';

-- ----------------------------
-- Records of sys_user_role
-- ----------------------------
BEGIN;
INSERT INTO `sys_user_role` (`id`, `role_id`, `user_id`)
VALUES (1, 1, 1);
INSERT INTO `sys_user_role` (`id`, `role_id`, `user_id`)
VALUES (2, 2, 2);
INSERT INTO `sys_user_role` (`id`, `role_id`, `user_id`)
VALUES (3, 3, 2);
INSERT INTO `sys_user_role` (`id`, `role_id`, `user_id`)
VALUES (4, 3, 3);
INSERT INTO `sys_user_role` (`id`, `role_id`, `user_id`)
VALUES (5, 3, 4);
INSERT INTO `sys_user_role` (`id`, `role_id`, `user_id`)
VALUES (6, 3, 5);
INSERT INTO `sys_user_role` (`id`, `role_id`, `user_id`)
VALUES (7, 3, 6);
COMMIT;

-- ----------------------------
-- Table structure for t_db_version
-- ----------------------------
DROP TABLE IF EXISTS `t_db_version`;
CREATE TABLE `t_db_version`
(
    `installed_rank` int           NOT NULL,
    `version`        varchar(50)            DEFAULT NULL,
    `description`    varchar(200)  NOT NULL,
    `type`           varchar(20)   NOT NULL,
    `script`         varchar(1000) NOT NULL,
    `checksum`       int                    DEFAULT NULL,
    `installed_by`   varchar(100)  NOT NULL,
    `installed_on`   timestamp     NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `execution_time` int           NOT NULL,
    `success`        tinyint(1)    NOT NULL,
    PRIMARY KEY (`installed_rank`) USING BTREE,
    KEY `t_db_version_s_idx` (`success`) USING BTREE
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4
  COLLATE = utf8mb4_general_ci
  ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of t_db_version
-- ----------------------------
BEGIN;
INSERT INTO `t_db_version` (`installed_rank`, `version`, `description`, `type`, `script`, `checksum`, `installed_by`,
                            `installed_on`, `execution_time`, `success`)
VALUES (1, '1.1', '20230509 Init DDL', 'SQL', 'V1.1__20230509_Init_DDL.sql', 829744681, 'root', '2025-01-18 09:25:39',
        673, 1);
INSERT INTO `t_db_version` (`installed_rank`, `version`, `description`, `type`, `script`, `checksum`, `installed_by`,
                            `installed_on`, `execution_time`, `success`)
VALUES (2, '1.2', '20240511 Update DDL', 'SQL', 'V1.2__20240511_Update_DDL.sql', 372977814, 'root',
        '2025-01-18 09:25:39', 6, 1);
INSERT INTO `t_db_version` (`installed_rank`, `version`, `description`, `type`, `script`, `checksum`, `installed_by`,
                            `installed_on`, `execution_time`, `success`)
VALUES (3, '1.3', '20240530 Update DDL', 'SQL', 'V1.3__20240530_Update_DDL.sql', 1784154531, 'root',
        '2025-01-18 09:25:39', 6, 1);
INSERT INTO `t_db_version` (`installed_rank`, `version`, `description`, `type`, `script`, `checksum`, `installed_by`,
                            `installed_on`, `execution_time`, `success`)
VALUES (4, '1.4', '20240603 Update DDL', 'SQL', 'V1.4__20240603_Update_DDL.sql', 1997095868, 'root',
        '2025-01-18 09:25:39', 2, 1);
INSERT INTO `t_db_version` (`installed_rank`, `version`, `description`, `type`, `script`, `checksum`, `installed_by`,
                            `installed_on`, `execution_time`, `success`)
VALUES (5, '1.5', '20240605 Update DDL', 'SQL', 'V1.5__20240605_Update_DDL.sql', 1391658357, 'root',
        '2025-01-18 09:25:39', 2, 1);
INSERT INTO `t_db_version` (`installed_rank`, `version`, `description`, `type`, `script`, `checksum`, `installed_by`,
                            `installed_on`, `execution_time`, `success`)
VALUES (6, '1.6', '20240611 Update DDL', 'SQL', 'V1.6__20240611_Update_DDL.sql', 75627697, 'root',
        '2025-01-18 09:25:39', 3, 1);
INSERT INTO `t_db_version` (`installed_rank`, `version`, `description`, `type`, `script`, `checksum`, `installed_by`,
                            `installed_on`, `execution_time`, `success`)
VALUES (7, '1.7', '20240624 Update DDL', 'SQL', 'V1.7__20240624_Update_DDL.sql', -404704373, 'root',
        '2025-01-18 09:25:39', 100, 1);
INSERT INTO `t_db_version` (`installed_rank`, `version`, `description`, `type`, `script`, `checksum`, `installed_by`,
                            `installed_on`, `execution_time`, `success`)
VALUES (8, '1.8', '20240726 Update DDL', 'SQL', 'V1.8__20240726_Update_DDL.sql', 2016440390, 'root',
        '2025-01-18 09:25:39', 24, 1);
INSERT INTO `t_db_version` (`installed_rank`, `version`, `description`, `type`, `script`, `checksum`, `installed_by`,
                            `installed_on`, `execution_time`, `success`)
VALUES (9, '1.9', '20240811 Update DDL', 'SQL', 'V1.9__20240811_Update_DDL.sql', -1874884231, 'root',
        '2025-01-18 09:25:39', 2, 1);
INSERT INTO `t_db_version` (`installed_rank`, `version`, `description`, `type`, `script`, `checksum`, `installed_by`,
                            `installed_on`, `execution_time`, `success`)
VALUES (10, '2.0', '20240813 Update DDL', 'SQL', 'V2.0__20240813_Update_DDL.sql', 1280585246, 'root',
        '2025-01-18 09:25:39', 12, 1);
INSERT INTO `t_db_version` (`installed_rank`, `version`, `description`, `type`, `script`, `checksum`, `installed_by`,
                            `installed_on`, `execution_time`, `success`)
VALUES (11, '2.1', '20241014 Update DDL', 'SQL', 'V2.1__20241014_Update_DDL.sql', -2022036290, 'root',
        '2025-01-18 09:25:39', 292, 1);
INSERT INTO `t_db_version` (`installed_rank`, `version`, `description`, `type`, `script`, `checksum`, `installed_by`,
                            `installed_on`, `execution_time`, `success`)
VALUES (12, '2.2', '20241119 Update DDL', 'SQL', 'V2.2__20241119_Update_DDL.sql', 223266239, 'root',
        '2025-01-18 09:25:39', 7, 1);
INSERT INTO `t_db_version` (`installed_rank`, `version`, `description`, `type`, `script`, `checksum`, `installed_by`,
                            `installed_on`, `execution_time`, `success`)
VALUES (13, '2.3', '20241125 Update DDL', 'SQL', 'V2.3__20241125_Update_DDL.sql', 243924568, 'root',
        '2025-01-18 09:25:39', 27, 1);
INSERT INTO `t_db_version` (`installed_rank`, `version`, `description`, `type`, `script`, `checksum`, `installed_by`,
                            `installed_on`, `execution_time`, `success`)
VALUES (14, '2.4', '20241203 Update DDL', 'SQL', 'V2.4__20241203_Update_DDL.sql', 990805520, 'root',
        '2025-01-18 09:25:40', 24, 1);
INSERT INTO `t_db_version` (`installed_rank`, `version`, `description`, `type`, `script`, `checksum`, `installed_by`,
                            `installed_on`, `execution_time`, `success`)
VALUES (15, '2.5', '20250107 Update DDL', 'SQL', 'V2.5__20250107_Update_DDL.sql', -1141433116, 'root',
        '2025-01-18 09:25:40', 4, 1);
COMMIT;

-- ----------------------------
-- Table structure for t_db_version_business
-- ----------------------------
DROP TABLE IF EXISTS `t_db_version_business`;
CREATE TABLE `t_db_version_business`
(
    `installed_rank` int           NOT NULL,
    `version`        varchar(50)            DEFAULT NULL,
    `description`    varchar(200)  NOT NULL,
    `type`           varchar(20)   NOT NULL,
    `script`         varchar(1000) NOT NULL,
    `checksum`       int                    DEFAULT NULL,
    `installed_by`   varchar(100)  NOT NULL,
    `installed_on`   timestamp     NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `execution_time` int           NOT NULL,
    `success`        tinyint(1)    NOT NULL,
    PRIMARY KEY (`installed_rank`),
    KEY `t_db_version_business_s_idx` (`success`)
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4
  COLLATE = utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of t_db_version_business
-- ----------------------------
BEGIN;
INSERT INTO `t_db_version_business` (`installed_rank`, `version`, `description`, `type`, `script`, `checksum`,
                                     `installed_by`, `installed_on`, `execution_time`, `success`)
VALUES (1, '1', '<< Flyway Baseline >>', 'BASELINE', '<< Flyway Baseline >>', NULL, 'root', '2025-01-18 09:25:40', 0,
        1);
COMMIT;

-- ----------------------------
-- Table structure for teacher_statistics
-- ----------------------------
DROP TABLE IF EXISTS `teacher_statistics`;
CREATE TABLE `teacher_statistics`
(
    `id`                  bigint      NOT NULL AUTO_INCREMENT COMMENT 'ID',
    `year`                varchar(4)  NOT NULL COMMENT '统计年限',
    `month`               varchar(2)  NOT NULL COMMENT '统计月份',
    `during_time`         varchar(10)          DEFAULT NULL COMMENT '统计年月',
    `teacher_id`          varchar(32) NOT NULL COMMENT '教师id',
    `teacher_common_type` int         NOT NULL COMMENT '讲师区分类型',
    `total_teaching`      int                  DEFAULT NULL COMMENT '授课总数',
    `total_class_count`   int                  DEFAULT NULL COMMENT '服务班次数',
    `total_hours`         decimal(10, 2)       DEFAULT NULL COMMENT '课时总数',
    `check_status`        int         NOT NULL DEFAULT '0' COMMENT '核对状态',
    `check_time`          datetime             DEFAULT NULL COMMENT '核对时间',
    `created_at`          datetime             DEFAULT NULL COMMENT '生成时间',
    `updated_at`          datetime             DEFAULT NULL COMMENT '更新时间',
    `last_sync_time`      datetime             DEFAULT NULL COMMENT '最近一次同步时间',
    `remark`              varchar(255)         DEFAULT NULL COMMENT '备注',
    `created_by`          bigint               DEFAULT NULL COMMENT '创建人ID',
    `updated_by`          bigint               DEFAULT NULL COMMENT '更新人ID',
    `dept_scope`          json                 DEFAULT NULL COMMENT '部门范围',
    PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB
  AUTO_INCREMENT = 28
  DEFAULT CHARSET = utf8mb4
  COLLATE = utf8mb4_general_ci
  ROW_FORMAT = DYNAMIC COMMENT ='教师统计总览表';

-- ----------------------------
-- Records of teacher_statistics
-- ----------------------------
BEGIN;
INSERT INTO `teacher_statistics` (`id`, `year`, `month`, `during_time`, `teacher_id`, `teacher_common_type`,
                                  `total_teaching`, `total_class_count`, `total_hours`, `check_status`, `check_time`,
                                  `created_at`, `updated_at`, `last_sync_time`, `remark`, `created_by`, `updated_by`,
                                  `dept_scope`)
VALUES (22, '2018', '12', '03', '1503', 1000001, 12, 22, 15.00, 1000001, '2024-07-08 10:39:56', '2024-07-08 10:40:16',
        NULL, '2024-07-08 10:39:57', 'test1 创建记录', 3, NULL, '[
    4
  ]');
INSERT INTO `teacher_statistics` (`id`, `year`, `month`, `during_time`, `teacher_id`, `teacher_common_type`,
                                  `total_teaching`, `total_class_count`, `total_hours`, `check_status`, `check_time`,
                                  `created_at`, `updated_at`, `last_sync_time`, `remark`, `created_by`, `updated_by`,
                                  `dept_scope`)
VALUES (23, '2019', '12', '03', '111', 1000001, 1, 2, 3.00, 1000001, '2024-07-08 10:41:09', '2024-07-08 10:41:18', NULL,
        '2024-07-08 10:41:11', 'test1 创建记录', 3, NULL, '[
    4
  ]');
INSERT INTO `teacher_statistics` (`id`, `year`, `month`, `during_time`, `teacher_id`, `teacher_common_type`,
                                  `total_teaching`, `total_class_count`, `total_hours`, `check_status`, `check_time`,
                                  `created_at`, `updated_at`, `last_sync_time`, `remark`, `created_by`, `updated_by`,
                                  `dept_scope`)
VALUES (24, '2020', '12', '2020-12', '023', 1000001, 1, 1, 1.00, 1000001, '2024-07-08 13:06:55', '2024-07-08 13:07:07',
        NULL, '2024-07-08 13:06:57', 'test1 创建记录', 3, NULL, '[
    4
  ]');
INSERT INTO `teacher_statistics` (`id`, `year`, `month`, `during_time`, `teacher_id`, `teacher_common_type`,
                                  `total_teaching`, `total_class_count`, `total_hours`, `check_status`, `check_time`,
                                  `created_at`, `updated_at`, `last_sync_time`, `remark`, `created_by`, `updated_by`,
                                  `dept_scope`)
VALUES (25, '2021', '12', '2021-12', '123', 1000001, 1, 1, 1.00, 1000001, '2024-07-08 13:13:56', '2024-07-08 13:13:59',
        NULL, NULL, 'test2 创建记录', 4, NULL, '[
    15
  ]');
INSERT INTO `teacher_statistics` (`id`, `year`, `month`, `during_time`, `teacher_id`, `teacher_common_type`,
                                  `total_teaching`, `total_class_count`, `total_hours`, `check_status`, `check_time`,
                                  `created_at`, `updated_at`, `last_sync_time`, `remark`, `created_by`, `updated_by`,
                                  `dept_scope`)
VALUES (26, '2022', '12', '2022-12', '13123', 1000001, 1, 1, 1.00, 1000001, '2024-07-08 13:15:36',
        '2024-07-08 13:15:37', '2024-07-08 13:15:46', NULL, 'test3 创建记录', 5, 5, '[
    15
  ]');
INSERT INTO `teacher_statistics` (`id`, `year`, `month`, `during_time`, `teacher_id`, `teacher_common_type`,
                                  `total_teaching`, `total_class_count`, `total_hours`, `check_status`, `check_time`,
                                  `created_at`, `updated_at`, `last_sync_time`, `remark`, `created_by`, `updated_by`,
                                  `dept_scope`)
VALUES (27, '2099', '12', '12', '123123', 1000001, 1, 1, 1.00, 1000001, NULL, '2024-07-08 13:20:29', NULL, NULL,
        '管理员创建', 1, NULL, '[
    1,
    2,
    3,
    4,
    5,
    6,
    7,
    8,
    9,
    10,
    11,
    12,
    13,
    14,
    15,
    16,
    17,
    18,
    19
  ]');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
